Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-sql - January 2006

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

2006-01-01

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)

2006-01-02

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)

2006-01-03

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)

2006-01-04

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)

2006-01-05

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)

2006-01-06

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)

2006-01-07

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)

2006-01-08

Re: INSERT waiting under heavy load Andrew Sullivan (18:21)

2006-01-09

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)

2006-01-10

Regexp group matching - extracting second group element? Mario Splivalo (14:18)

2006-01-11

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)

2006-01-12

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)

2006-01-13

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)

2006-01-14

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)

2006-01-15

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)

2006-01-16

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)

2006-01-17

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)

2006-01-18

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)

2006-01-19

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)

2006-01-20

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)

2006-01-21

Re: indexing for left join Zulq Alam (13:51)

2006-01-22

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)

2006-01-23

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)

2006-01-24

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)

2006-01-25

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 storedprocedure? 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)

2006-01-26

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)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group