pgsql-sql - January 2006

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Jan. 1, 2006

Thread Author Time
plpgsql triggers in rules chester c young 18:19
session variables in 8.0 chester c young 18:21
exceptions in rules chester c young 18:22

Jan. 2, 2006

Thread Author Time
avg() with floating-point types George Pavlov 00:40
Re: avg() with floating-point types Tom Lane 01:25
Re: avg() with floating-point types Michael Fuhr 01:27
PostgreSQL and uuid/guid Mario Splivalo 13:26
delete from a using b in postgres 8.1. Peter Childs 13:28

Jan. 3, 2006

Thread Author Time
Re: delete from a using b in postgres 8.1. Jaime Casanova 19:18
getting a query column to return 0 if nothing matches Dan Tenenbaum 22:15

Jan. 4, 2006

Thread Author Time
Loading lots of data in a SQL command frank church 01:32
Re: getting a query column to return 0 if nothing matches Michael Fuhr 02:42
Re: Loading lots of data in a SQL command Richard Huxton 09:21
Regular Expression Matching problem... Mario Splivalo 14:08
Re: Regular Expression Matching problem... A. Kretschmer 14:50
Re: Regular Expression Matching problem... Michael Fuhr 17:00
JOIN question with multiple records Scott, Casey 19:54

Jan. 5, 2006

Thread Author Time
FOREIGN KEYs ... I think ... Marc G. Fournier 01:49
Re: FOREIGN KEYs ... I think ... Tom Lane 01:54
Re: FOREIGN KEYs ... I think ... Marc G. Fournier 03:12
Re: FOREIGN KEYs ... I think ... Jim Johannsen 03:31
Re: FOREIGN KEYs ... I think ... nospam 03:58
Re: JOIN question with multiple records Richard Huxton 08:40
Re: FOREIGN KEYs ... I think ... Leif B. Kristensen 11:39

Jan. 6, 2006

Thread Author Time
Re: FOREIGN KEYs ... I think ... Marc G. Fournier 01:23
Re: PostgreSQL and uuid/guid george young 02:38
INSERT waiting under heavy load alex-lists-pgsql 18:42
Re: INSERT waiting under heavy load alex-lists-pgsql 20:16
Re: INSERT waiting under heavy load Tom Lane 20:52
Re: INSERT waiting under heavy load Tom Lane 21:49

Jan. 7, 2006

Thread Author Time
how to transform list to table and evaluate an expression on it? Tomas Vondra 16:03
Re: how to transform list to table and evaluate an Frank Bax 20:47

Jan. 8, 2006

Thread Author Time
Re: INSERT waiting under heavy load Andrew Sullivan 18:21

Jan. 9, 2006

Thread Author Time
Re: Regular Expression Matching problem... Mario Splivalo 01:22
system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford 19:33
Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. Tom Lane 20:23
Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford 21:01
Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. Tom Lane 21:37
Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford 23:03

Jan. 10, 2006

Thread Author Time
Regexp group matching - extracting second group element? Mario Splivalo 14:18

Jan. 11, 2006

Thread Author Time
Unable to identify an ordering operator '<' for type 'smallint[]' Mauricio Fernandez A. 17:55
Re: Unable to identify an ordering operator '<' for type 'smallint[]' Jaime Casanova 18:14
Re: Unable to identify an ordering operator '<' for type 'smallint[]' Tom Lane 18:24
psql client: technique for applying default values to :variables? Jeff Boes 18:48
Re: Unable to identify an ordering operator '<' for type 'smallint[]' Mauricio Fernandez A. 20:07
foreign keys with on delete cascade and triggers Dirk Jagdmann 22:56
Re: psql client: technique for applying default values to :variables? Tony Wasson 23:51

Jan. 12, 2006

Thread Author Time
Re: foreign keys with on delete cascade and triggers Tom Lane 03:02
error code invalid_input_syntax Rainer Leo 08:43
Re: foreign keys with on delete cascade and triggers Dirk Jagdmann 11:49
Re: foreign keys with on delete cascade and triggers Tom Lane 15:46
Re: error code invalid_input_syntax Tom Lane 16:05
Re: plpgsql triggers in rules Markus Schaber 17:01
Re: exceptions in rules Markus Schaber 17:04

Jan. 13, 2006

Thread Author Time
info is a reserved word? John DeSoi 01:14
Re: info is a reserved word? Michael Fuhr 01:29
Re: info is a reserved word? Tom Lane 04:21
Re: info is a reserved word? Michael Fuhr 04:57
Re: [SQL] info is a reserved word? Tom Lane 05:10
ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel 14:32
Re: ORDER BY does not work as expected with multiple joins Tom Lane 14:56
Re: ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel 15:14
Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann 15:19
Re: ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel 15:22
Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann 15:45
Re: ORDER BY does not work as expected with multiple joins Tom Lane 15:56
Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann 16:07
Re: ORDER BY does not work as expected with multiple joins Jaime Casanova 16:20

Jan. 14, 2006

Thread Author Time
Another orderby problem Alan Chandler 13:02
Re: Another orderby problem A. Kretschmer 13:09
Re: Another orderby problem D'Arcy J.M. Cain 13:13
Re: Another orderby problem Alan Chandler 14:28
Re: psql client: technique for applying default values to :variables? 📎 Jeff Boes 14:54
Re: psql client: technique for applying default values to :variables? Michael Glaesemann 22:38

Jan. 15, 2006

Thread Author Time
select and as doubt Alexandre Gonçalves Jacarandá 03:55
Re: select and as doubt Tom Lane 04:28
Trigger for Large Object Modification Andreas Roth 10:12
Re: select and as doubt Alexandre Gonçalves Jacarandá 14:59
What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator) 20:25
Re: What does "merge-joinable join conditions" mean ???? Michael Fuhr 21:54
Re: What does "merge-joinable join conditions" mean ???? Tom Lane 21:58
Re: What does "merge-joinable join conditions" mean ???? Tom Lane 22:19
Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator) 22:28
Re: What does "merge-joinable join conditions" mean ???? Tom Lane 23:21
Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator) 23:31
Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator) 23:47

Jan. 16, 2006

Thread Author Time
Re: What does "merge-joinable join conditions" mean ???? Tom Lane 00:10
Executing plpgsql scripts using psql, is that possible? Daniel CAUNE 10:35
Re: Executing plpgsql scripts using psql, is that possible? John DeSoi 13:50
Re: psql client: technique for applying default values to :variables? Jeff Boes 15:33
For update Ottó Havasvölgyi 16:59
Re: psql client: technique for applying default values to :variables? Andreas Seltenreich 17:02
Re: For update Alvaro Herrera 17:05
Re: For update Michael Fuhr 17:29
best way for constants in the database chester c young 18:49
Re: best way for constants in the database Owen Jacobson 18:53
Re: For update Ottó Havasvölgyi 21:33
Re: For update Alvaro Herrera 21:37
Re: For update Ottó Havasvölgyi 22:15
Re: For update Ottó Havasvölgyi 23:51

Jan. 17, 2006

Thread Author Time
Re: Executing plpgsql scripts using psql, is that possible? Daniel CAUNE 01:55
Re: Executing plpgsql scripts using psql, is that possible? Adrian Klaver 02:35
Re: Executing plpgsql scripts using psql, is that possible? John DeSoi 02:54
Re: Executing plpgsql scripts using psql, is that possible? Daniel CAUNE 03:10
Re: Characters that needs escape characters when inserting to database Michael Glaesemann 07:20
Re: Characters that needs escape characters when inserting to database Michael Fuhr 17:56
non-equi self-join optimization George Pavlov 20:57
Characters that needs escape characters when inserting to database Christian Paul B. Cosinas 22:21

Jan. 18, 2006

Thread Author Time
Still struggling with history tables Ken Winter 03:29
Matching several rows Ivan Steganov 04:43
Re: Matching several rows Michael Glaesemann 05:04
bug with if ... then ... clause in views Emil Rachovsky 09:18
Re: [SQL] bug with if ... then ... clause in views Michael Glaesemann 09:28
Re: Still struggling with history tables Michael Glaesemann 09:59
Re: Still struggling with history tables Achilleus Mantzios 10:23
Re: Matching several rows Volkan YAZICI 11:55
Re: bug with if ... then ... clause in views Daryl Richter 12:32
Re: Matching several rows Michael Glaesemann 12:33
Re: Matching several rows Volkan YAZICI 12:48
Re: Matching several rows Michael Glaesemann 12:59
Re: Matching several rows Ivan Steganov 14:22
Re: Matching several rows Patrick JACQUOT 14:28
Re: bug with if ... then ... clause in views Jeff 15:41
Re: Matching several rows Vraj Mohan 16:35
Re: Characters that needs escape characters when inserting to database Christian Paul B. Cosinas 21:33
stored procedures for complex SELECTs alex-lists-pgsql 23:17
Re: stored procedures for complex SELECTs Michael Glaesemann 23:39

Jan. 19, 2006

Thread Author Time
Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris 12:39
Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Michael Glaesemann 12:48
Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris 13:06
indexing for left join T E Schmitz 15:41
Re: indexing for left join Richard Huxton 15:52
Re: indexing for left join Rod Taylor 15:57
Re: indexing for left join T E Schmitz 16:42
Re: indexing for left join T E Schmitz 16:42
Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Leif B. Kristensen 16:45
Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Michael Glaesemann 22:38

Jan. 20, 2006

Thread Author Time
Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris 06:52
Re: Error calling self-made plpgsql function "function XYZ(bigint) Markus Schaber 10:56

Jan. 21, 2006

Thread Author Time
Re: indexing for left join Zulq Alam 13:51

Jan. 22, 2006

Thread Author Time
How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? Jesper K. Pedersen 20:13
Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? Tom Lane 20:46
Re: How to implement Microsoft Access boolean (YESNO) Jesper K. Pedersen 21:13

Jan. 23, 2006

Thread Author Time
DBMirror.pl performance change 📎 Achilleus Mantzios 10:57
Re: select and as doubt Bruno Wolff III 16:44
pgadmin Mark Fenbers 18:29
Re: pgadmin Owen Jacobson 19:35
Re: pgadmin Tom Lane 19:37
Re: How to implement Microsoft Access boolean (YESNO) Greg Stark 20:53
Re: How to implement Microsoft Access boolean (YESNO) Tom Lane 21:02

Jan. 24, 2006

Thread Author Time
Re: How to implement Microsoft Access boolean (YESNO) Greg Stark 05:03
Re: non-equi self-join optimization Bruno Wolff III 09:04
Re: How to implement Microsoft Access boolean (YESNO) PFC 10:14
Re: How to implement Microsoft Access boolean (YESNO) Tom Lane 14:59
Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? codeWarrior 16:08

Jan. 25, 2006

Thread Author Time
Re: How to implement Microsoft Access boolean (YESNO) Bath, David 01:05
sorting by day of the week Joseph Shraibman 01:23
Re: sorting by day of the week Joseph Shraibman 02:39
Fw: stored procedures for complex SELECTs ipv 03:01
Re: sorting by day of the week ipv 03:14
hi all......................!! AKHILESH GUPTA 06:27
Re: hi all......................!! Tino Wildenhain 06:50
Re: [SQL] hi all......................!! Richard Huxton 09:24
Re: [SQL] hi all......................!! Markus Schaber 09:27
Changing the transaction isolation level within the stored procedure? Mario Splivalo 14:12
Re: Changing the transaction isolation level within the stored Markus Schaber 14:54
psql in the command line Aniko.Badzong 15:57
Re: psql in the command line Alvaro Herrera 16:05
Re: Changing the transaction isolation level within the stored procedure? Jaime Casanova 16:46
filtering after join andrew 17:27
Re: psql in the command line Owen Jacobson 17:43
Re: filtering after join Michael Fuhr 17:53
Re: filtering after join Peter Eisentraut 19:11
Re: filtering after join andrew 20:13

Jan. 26, 2006

Thread Author Time
Re: Changing the transaction isolation level within the Mario Splivalo 07:08
Re: Changing the transaction isolation level within the Mario Splivalo 07:11
Re: Changing the transaction isolation level within the Markus Schaber 08:41
Re: Changing the transaction isolation level within the stored Markus Schaber 09:42
Physical column size Paul Mackay 10:06
Re: filtering after join Peter Eisentraut 10:27
Re: filtering after join andrew 10:54
Re: Physical column size Mario Weilguni 11:22
Re: filtering after join Peter Eisentraut 11:22
Re: Changing the transaction isolation level within the stored Andrew Sullivan 11:39
question with times and intervals A. Kretschmer 11:58
Re: question with times and intervals Richard Huxton 12:09
Re: question with times and intervals Andreas Kretschmer 12:46
Re: Changing the transaction isolation level within the stored Markus Schaber 12:51
Re: filtering after join andrew 12:54
Re: Changing the transaction isolation level within the stored Stephan Szabo 15:28
Query optimization with X Y JOIN J 15:43
Re: Query optimization with X Y JOIN Craig A. James 16:12
Re: Query optimization with X Y JOIN J 16:25
Re: [PERFORM] Query optimization with X Y JOIN Jaime Casanova 16:33
Re: Query optimization with X Y JOIN Joshua D. Drake 16:34
Re: Changing the transaction isolation level within the stored Andrew Sullivan 16:39
Re: Query optimization with X Y JOIN Richard Huxton 16:47
Re: filtering after join Peter Eisentraut 16:59
[HELP] Defining a function as a procedure Daniel Caune 17:09
Re: Query optimization with X Y JOIN J 17:13

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31