pgsql-sql since 2006-03-02 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

March 2, 2006

Thread	Author	Time
Re: [SQL] Interval subtracting	Mark Dilger	00:02
Re: [SQL] Interval subtracting	Tom Lane	00:37
Re: [SQL] Interval subtracting	Mark Dilger	01:18
Re: Change date format through an environmental variable?	Tom Lane	06:16
Re: [SQL] Interval subtracting	Hannu Krosing	06:45
Re: [SQL] Interval subtracting	Tino Wildenhain	07:05
Re: Change date format through an environmental variable?	Michael Fuhr	07:33
Re: Change date format through an environmental variable?	Michael Fuhr	07:42
Re: Change date format through an environmental variable?	Peter Eisentraut	08:46
dump with lo	Maciej Piekielniak	11:41
Re: Help with trigger that updates a row prior to a potentially aborted deletion?	Andrew Sullivan	12:19
Without OIDs	Emil Rachovsky	13:14
FW: sql copy does not work	Aniko.Badzong	14:26
Re: [SQL] Interval subtracting	Tom Lane	14:49
Re: dump with lo	Tom Lane	15:21
Re: Change date format through an environmental variable?	george young	15:33
Re: [SQL] Without OIDs	Michael Fuhr	15:57
Re: [SQL] Interval subtracting	Scott Marlowe	16:13
Question about Sql SELECT and optimizer	Chaz.	16:19
Re: dump with lo	Maciej Piekielniak	16:59
Re: Question about Sql SELECT and optimizer	Michael Fuhr	17:04
Re: [SQL] Interval subtracting	Hannu Krosing	17:50
Re: [SQL] Interval subtracting	Mark Dilger	18:06
Re: [SQL] Interval subtracting	Martijn van Oosterhout	18:43
Re: [SQL] Interval subtracting	Tom Lane	19:10
Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?	Davidson, Robert	22:33
Re: Why can't I use daylight savings time aware time zones with the AT TIME ZONE clause?	Michael Fuhr	22:49

March 3, 2006

Thread	Author	Time
Re: Help with trigger that updates a row prior to a potentially aborted deletion?	Simon Kinsella	00:19
How to check date-interval constraints	Andreas	03:28
Re: How to check date-interval constraints	Michael Fuhr	05:13
Re: How to check date-interval constraints	Michael Glaesemann	05:25
Sequential scan where Index scan expected.	Bryce Nesbitt	07:27
Sequential scan where Index scan expected (update)	Bryce Nesbitt	07:28
Re: Sequential scan where Index scan expected (update)	Gregory S. Williamson	07:37
Why do I get these results?????	Joost Kraaijeveld	08:50
Re: Why do I get these results?????	Joost Kraaijeveld	09:27
Re: Sequential scan where Index scan expected (update)	Ragnar	09:31
newbie question	ivan marchesini	09:43
Re: Sequential scan where Index scan expected (update)	Michael Fuhr	09:46
Re: Why do I get these results?????	Ragnar	09:51
Physical column size	Paul Mackay	10:03
Re: Physical column size	Peter Eisentraut	10:23
Re: Physical column size	Martijn van Oosterhout	10:23
Re: Physical column size	Ragnar	10:27
Re: Why do I get these results?????	Joost Kraaijeveld	10:42
Re: newbie question	Andreas Kretschmer	10:51
Re: newbie question	Karsten Hilbert	11:04
Re: newbie question	ivan marchesini	11:30
Re: newbie question	A. Kretschmer	12:40
Re: Help with trigger that updates a row prior to a potentially aborted deletion?	Andrew Sullivan	12:42
Re: newbie question	Karsten Hilbert	12:46
Re: Sequential scan where Index scan expected (update)	Andrew Sullivan	12:47
Re: Physical column size	Tom Lane	14:53
how to make infinite intervals?	Tilman Baumann	17:01
Re: how to make infinite intervals?	Tilman Baumann	17:09
Re: how to make infinite intervals?	Bruce Momjian	17:13
Re: how to make infinite intervals?	Tom Lane	19:02
Re: Sequential scan where Index scan expected (update)	Bryce Nesbitt	19:35
Re: Sequential scan where Index scan expected (update)	Andrew Sullivan	19:40
pg_dump and diffrent sizes	Maciej Piekielniak	20:10
Re: pg_dump and diffrent sizes	Scott Marlowe	20:15
Re: [SQL] Interval subtracting 📎	Mark Dilger	20:25

March 4, 2006

Thread	Author	Time
Getting yyyy-mm-dd 00:00:00 in an arbitrary time zone	Davidson, Robert	00:13
Re: Getting yyyy-mm-dd 00:00:00 in an arbitrary time zone	Tom Lane	00:32
Re: Getting yyyy-mm-dd 00:00:00 in an arbitrary time zone	Davidson, Robert	04:34
Re: Sequential scan where Index scan expected.	Nikolay Samokhvalov	19:07
unsubscribe	Peter Ivarsson	20:37

March 5, 2006

Thread	Author	Time
Check/unique constraint question	Jeff Frost	08:25
Re: Check/unique constraint question	Nikolay Samokhvalov	09:02
Re: Check/unique constraint question	Nikolay Samokhvalov	09:49
Re: Check/unique constraint question	Volkan YAZICI	10:05
Re: Check/unique constraint question	Karsten Hilbert	10:29
Re: Check/unique constraint question	Michael Glaesemann	11:50
functions in WHERE clause	sramsay	15:16
Re: functions in WHERE clause	Michael Fuhr	17:26
Re: functions in WHERE clause	sramsay	17:48
Re: functions in WHERE clause	Tom Lane	17:59
Re: functions in WHERE clause	Tom Lane	18:16
Re: Check/unique constraint question	Jeff Frost	18:32
Re: functions in WHERE clause	sramsay	18:49
Re: functions in WHERE clause	Stephan Szabo	19:38
Re: functions in WHERE clause	sramsay	20:10
Re: functions in WHERE clause	Stephan Szabo	20:23
Help with distinctly non-intuitive rule behaviour	Simon Kinsella	21:18
Re: Help with distinctly non-intuitive rule behaviour	Tom Lane	21:59
Re: functions in WHERE clause	Greg Stark	22:22

March 6, 2006

Thread	Author	Time
Visual and PostgreSQL	Michael Louie Loria	01:23
problem with overloading the "coalesce" function	Emil Rachovsky	10:18
Re: problem with overloading the "coalesce" function	Richard Huxton	10:41
Re: problem with overloading the "coalesce" function	Emil Rachovsky	11:13
Re: problem with overloading the "coalesce" function	Richard Huxton	11:29
Help with "missing FROM clause" needed	Thomas Beutin	13:25
Re: Help with "missing FROM clause" needed	Richard Huxton	13:55
Re: Help with "missing FROM clause" needed	A. Kretschmer	13:57
Re: Help with "missing FROM clause" needed	Thomas Beutin	14:27
Re: Help with "missing FROM clause" needed	A. Kretschmer	14:51
Syntax error in Execute statement	Emil Rachovsky	15:21
Re: Help with "missing FROM clause" needed	Greg Stark	15:55
Re: Syntax error in Execute statement	Michael Fuhr	18:30

March 7, 2006

Thread	Author	Time
Re: problem with overloading the "coalesce" function	Tom Lane	02:39

March 8, 2006

Thread	Author	Time
Re: [SQL] Interval subtracting	Markus Schaber	12:07
Re: [SQL] Interval subtracting	Scott Marlowe	15:47
Re: [SQL] Interval subtracting	Tom Lane	15:54
Errors ignored on restore	Emil Rachovsky	16:11
Re: Errors ignored on restore 📎	Louis Gonzales	16:13
Re: Errors ignored on restore	Tom Lane	16:24
Re: [HACKERS] Interval subtracting	PFC	21:23
Is there any way to stop triggers from cycling?	Josh Berkus	21:58
Re: Is there any way to stop triggers from cycling?	Rod Taylor	22:35
Re: Is there any way to stop triggers from cycling?	chester c young	23:04
Re: Is there any way to stop triggers from cycling?	Josh Berkus	23:29

March 9, 2006

Thread	Author	Time
Re: Is there any way to stop triggers from cycling?	Richard Huxton	10:21
Problems with disabling triggers in Postgres 7.3.9	Flávio Suguimoto	13:18
[No subject] 📎	Klay Martens	13:35
Re:	Leif B. Kristensen	13:49
Re:	A. Kretschmer	13:53
Re: Problems with disabling triggers in Postgres 7.3.9	Alvaro Herrera	13:55
Re:	Richard Huxton	13:59
Re: Problems with disabling triggers in Postgres 7.3.9	Flávio Suguimoto	14:04
Re: Problems with disabling triggers in Postgres 7.3.9	Flávio Suguimoto	14:25
Re: Problems with disabling triggers in Postgres 7.3.9	Richard Huxton	14:41
Re: Problems with disabling triggers in Postgres 7.3.9	Flávio Suguimoto	15:11
Re: Problems with disabling triggers in Postgres 7.3.9	Tom Lane	15:50

March 10, 2006

Thread	Author	Time
Set generating functions and subqueries	Markus Schaber	12:19
Re:	Markus Schaber	12:40
Re: pg reserved words	Markus Schaber	13:09
Re: dbLink Query	Markus Schaber	13:12
How can I selet rows which have 2 columns values cross equal?	Fay Du	13:24
Re: How can I selet rows which have 2 columns values cross equal?	Milorad Poluga	14:27
Re: How can I selet rows which have 2 columns values cross equal?	PFC	14:32
Re: Set generating functions and subqueries	Tom Lane	14:48
Re: How can I selet rows which have 2 columns values cross equal?	Bruno Wolff III	17:31
Locking row	Flavio Suguimoto	20:50
Re: Locking row	Larry Rosenman	20:57

March 11, 2006

Thread	Author	Time
Advice on setting up a grid like view for spreadsheet users 📎	Bryce Nesbitt	00:17
READ COMMITTE without START TRANSACTION?	ogjunk-pgjedan	01:08
Re: READ COMMITTE without START TRANSACTION?	Jaime Casanova	03:44
Re: Locking row	Michael Fuhr	06:33
Re: How can I selet rows which have 2 columns values cross equal?	Michael Glaesemann	07:46
Re: How can I selet rows which have 2 columns values cross equal?	Michael Glaesemann	09:35
input from a external text file......!	AKHILESH GUPTA	10:29
Re: input from a external text file......!	Andreas Kretschmer	10:33
Re: [SQL] input from a external text file......!	PFC	11:29
Merging rows into one result?	Jesper K. Pedersen	16:31
Re: Merging rows into one result?	Andreas Kretschmer	16:43
Re: Merging rows into one result?	Volkan YAZICI	16:48
Re: Merging rows into one result?	Jesper K. Pedersen	16:58
Re: Merging rows into one result?	Christopher Browne	17:00

March 12, 2006

Thread	Author	Time
pgsql aggregate: conditional max	Weimao Ke	05:09
Re: pgsql aggregate: conditional max	Jeffrey Melloy	05:34
Re: pgsql aggregate: conditional max	Michael Fuhr	05:42
Re: pgsql aggregate: conditional max	Michael Fuhr	05:48
Re: pgsql aggregate: conditional max	Daniel CAUNE	14:05
Re: pgsql aggregate: conditional max	Weimao Ke	16:55
Re: pgsql aggregate: conditional max	Weimao Ke	17:07
Question re: relational technique	Robert Paulsen	17:11
Re: Question re: relational technique	chester c young	17:29
Re: Question re: relational technique	Robert Paulsen	18:15
Re: pgsql aggregate: conditional max	Weimao Ke	19:59

March 13, 2006

Thread	Author	Time
Re: Ask a PostgreSql question (about select )	Michael Glaesemann	03:53
Re: Question re: relational technique	Richard Huxton	09:03
how to get current recursion level in recursive trigger?	Андрей Долин	09:09
Permission to Select	Eugene E.	09:51
Constraint Error effect on PostgreSQL	Christian Paul B. Cosinas	11:25
Re: Question re: relational technique	Robert Paulsen	12:15
Re: Set generating functions and subqueries	Markus Schaber	12:34
removing "not null" modifier	Robert Urban	13:07
Re: Ask a PostgreSql question (about select )	Daniel Caune	14:21
Re: Permission to Select	Rod Taylor	14:33
Re: Permission to Select	Alvaro Herrera	14:46
Re: Set generating functions and subqueries	Tom Lane	14:57
Re: removing "not null" modifier	Achilleus Mantzios	15:04
Re: Permission to Select	Rod Taylor	15:10
Re: Permission to Select	Tom Lane	15:27
connectby documentation	Daniel Caune	15:37
Re: removing "not null" modifier	Tom Lane	15:47
Re: connectby documentation	Michael Fuhr	16:12
Re: Constraint Error effect on PostgreSQL	Richard Huxton	17:39
Re: Permission to Select	PFC	20:51
Re: connectby documentation	Daniel Caune	21:31
Re: connectby documentation	Lucius Seneca	21:39
Re: connectby documentation	PFC	21:45
Re: connectby documentation	Daniel Caune	21:56
Update value to "the first character is capital and the rest is small"	Emi Lu	22:31
Re: [SQL] Update value to "the first character is capital and the rest is small"	Alvaro Herrera	22:36
Re: Update value to "the first character is capital and	Emi Lu	22:37
Re: connectby documentation	Michael Fuhr	22:53
Re: [GENERAL] Update value to "the first character is capital	Emi Lu	22:55
Re: connectby documentation	Daniel Caune	23:02
Re: connectby documentation	Daniel Caune	23:38

March 14, 2006

Thread	Author	Time
Re: connectby documentation	Michael Fuhr	00:25
Re: connectby documentation	Daniel Caune	00:29
Re: connectby documentation	Michael Fuhr	01:02
unsubscribe	Arulmani V A	04:04
unsubscribe	RaFaeL	04:09
unsubscribe	Kenneth Hutchinson	04:25
Re: Permission to Select	Eugene E.	05:59
Re: Permission to Select	Eugene E.	06:06
Re: Permission to Select -- I am wrong	Eugene E.	06:10
Copying a row within table	Aarni Ruuhimäki	07:19

Browse Archives

Prev | Next