pgsql-sql since 2003-10-13 00:00

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

Oct. 13, 2003

Thread	Author	Time
[postgres] Foreign Key	Stefan Sturm	08:55
Re: [postgres] Foreign Key	Alvar Freude	10:37
Re: [postgres] Foreign Key	Stefan Sturm	10:47
Re: [postgres] Foreign Key	Stefan Sturm	10:51
Re: [postgres] Foreign Key	Stefan Sturm	10:54
Re: [postgres] Foreign Key	Alvar Freude	10:56
Re: [postgres] Foreign Key	Stefan Sturm	11:01
[postgres] Antwort von Microsoft auf Mail hier!	Alvar Freude	12:18
Re: [postgres] Antwort von Microsoft auf Mail hier!	Danny Tramnitzke	12:29
Re: [postgres] Antwort von Microsoft auf Mail hier!	Alvar Freude	12:37
removing precision from timestamp (microseconds) ..	Marc G. Fournier	14:04
Re: sql performance and cache	johnnnnnn	16:19
Re: [postgres] Antwort von Microsoft auf Mail hier!	Ian Barwick	17:15
Escaping the $1 parameter in stored procedures	robert	20:18
SSL	2000info	20:27

Oct. 14, 2003

Thread	Author	Time
Re: [postgres] Antwort von Microsoft auf Mail hier!	Cornelia Boenigk	07:20
Re: [SQL] SQL query problem (many table in FROM statement and many LEFT JOIN's)	Tom Lane	14:35
Re: [SQL] sql performance and cache	Tom Lane	16:14
Re: [SQL] sql performance and cache	Wei Weng	16:48
Re: about postgre SQL download	Richard Huxton	17:25
Re: [SQL] sql performance and cache	scott.marlowe	17:26
Re: Oracle 'connect by prior' now eaiser in 7.3?	Joe Conway	17:45
How to determine the current user	Michael Brusser	18:05
Re: security definer function	Peter Eisentraut	18:13
Re: sql performance and cache	Rod Taylor	18:15
Re: get diagnostics not supported by ecpg?	Peter Eisentraut	18:34
Re: How to determine the current user	Sean Chittenden	19:14

Oct. 15, 2003

Thread	Author	Time
Create View	Muhyiddin A.M Hayat	01:01
How can I produce the following desired result?	aicean	02:09
Re: How can I produce the following desired result?	Rod Taylor	02:27
Re: How can I produce the following desired result?	aicean	03:02
Sorting problem	George A.J	03:30
Re: Sorting problem	Stephan Szabo	03:39
Re: Create View	Richard Huxton	08:17
Re: about postgre SQL download	Richard Huxton	13:17
Re: Escaping the $1 parameter in stored procedures	robert	14:12
Re: How can I produce the following desired result?	greg	14:48
Re: How can I produce the following desired result?	Jean-Luc Lachance	15:36
Re: Sorting problem	Jean-Luc Lachance	15:42
indexing timestamp fields	teknokrat	15:56
Re: indexing timestamp fields	Christopher Browne	16:21
Calc	Muhyiddin A.M Hayat	19:59
Re: indexing timestamp fields	teknokrat	20:25
Re: Calc	Steve Crawford	20:31
Re: indexing timestamp fields	Christopher Browne	21:31
SQL function to validate money input	Zhao, Scott	21:46
Re: Calc	Josh Berkus	22:15

Oct. 16, 2003

Thread	Author	Time
convert integer seconds to timestamp	Wilson Fletcher	03:31
Re: convert integer seconds to timestamp	Wilson Fletcher	03:39
Re: convert integer seconds to timestamp	Wilson Fletcher	03:44
Re: Sorting problem	R. van Twisk	06:25
Re: SQL function to validate money input	Richard Huxton	12:50
Re: Alias-Error	Tom Lane	14:43
Re: indexing timestamp fields	Bruno Wolff III	16:56
Re: Calc	Steve Crawford	17:35
Re: Calc	Muhyiddin A.M Hayat	17:37
Add column with specific colid	Olga Macias	17:59
Can't convert numeric to_char() in catenate function	Yusuf	22:24
Postgres with OpenSSL	2000info	22:53
Re: Can't convert numeric to_char() in catenate function	Josh Berkus	23:04
Re: Can't convert numeric to_char() in catenate function	Yusuf	23:26
Re: Postgres with OpenSSL	Jordan S. Jones	23:26
Re: Postgres with OpenSSL	Jordan S. Jones	23:37

Oct. 17, 2003

Thread	Author	Time
Re: Calc	Muhyiddin A.M Hayat	01:38
Object description at Client Window	Kumar	06:06
Re: Object description at Client Window	Jordan S. Jones	06:20
Re: Object description at Client Window	Kumar	08:44
Re: Object description at Client Window	Richard Huxton	09:24
[postgres] IPv6-Datentyp(en) in PostgreSQL?	stephan.rupp	10:39
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL?	Ewald Geschwinde	11:43
Re: Object description at Client Window	Kumar	12:09
Re: Object description at Client Window	Kumar	12:37
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL? 📎	stephan.rupp	13:46
Re: [postgres] IPv6-Datentyp(en) in PostgreSQL?	Ewald Geschwinde	14:12
Re: Object description at Client Window	achill	14:33
Re: Object description at Client Window	George Weaver	14:49
new max function	Rodrigo Gesswein	18:13
Re: new max function	Mike Rylander	21:32

Oct. 18, 2003

Thread	Author	Time
Re: new max function	Tom Lane	02:51
Re: Postgres with OpenSSL	Roberto Mello	18:52
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen	Ian Barwick	21:54

Oct. 19, 2003

Thread	Author	Time
date_trunc for 5 minutes intervals	email lists	13:38
problem with sql	Adaś	16:56
Re: date_trunc for 5 minutes intervals	Mathieu Arnold	21:00

Oct. 20, 2003

Thread	Author	Time
Which is faster SQL or PL/PGSQL	George A.J	02:57
Re: Which is faster SQL or PL/PGSQL	Christopher Browne	03:48
Re: Which is faster SQL or PL/PGSQL	Josh Berkus	05:29
Max input parameter for a function	Kumar	06:28
Re: date_trunc for 5 minutes intervals	Richard Huxton	08:27
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen	Alvar Freude	09:43
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen	Alvar Freude	09:46
query or design question	Adam Witney	10:58
Re: Max input parameter for a function	Christopher Browne	12:29
Question regarding triggers	Dmitri Fuerle	13:00
Unable to user pg_restore	Kumar	13:01
Re: date_trunc for 5 minutes intervals	email lists	13:04
Scripting only the functions	Kumar	13:04
Re: Question regarding triggers	achill	13:22
Re: Question regarding triggers	A.Bhuvaneswaran	13:31
Re: Question regarding triggers	Tom Lane	13:48
Re: Question regarding triggers	achill	13:56
Re: Question regarding triggers	Dmitri Fuerle	15:07
Re: Which is faster SQL or PL/PGSQL	Michael Pohl	15:36
Re: Unable to user pg_restore	Tom Lane	16:49
Re: Which is faster SQL or PL/PGSQL	Richard Huxton	17:09
Re: query or design question	Richard Huxton	17:12
Re: [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen	weigelt	17:18
Re: Scripting only the functions	Josh Berkus	17:21
Re: Scripting only the functions	Richard Huxton	17:23
Re: Which is faster SQL or PL/PGSQL	Joe Conway	17:24
Re: Which is faster SQL or PL/PGSQL	Richard Huxton	17:49
[postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org	Peter Eisentraut	17:53
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter	Alvar Freude	17:57
Re: Which is faster SQL or PL/PGSQL	Joe Conway	18:11
Re: Which is faster SQL or PL/PGSQL	Josh Berkus	18:24
Crosstab question	Adam Witney	18:40
Re: Which is faster SQL or PL/PGSQL	Joe Conway	18:54
Re: Which is faster SQL or PL/PGSQL	Josh Berkus	19:00
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org	weigelt	19:05
Re: Which is faster SQL or PL/PGSQL	Tom Lane	19:50
Re: Crosstab question	Joe Conway	19:51
Re: [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org	Ewald Geschwinde	19:52
Re: Which is faster SQL or PL/PGSQL	Josh Berkus	20:58
converting an oracle procedure to postgres	Clint Stotesbery	21:20
Re: converting an oracle procedure to postgres	Josh Berkus	21:28
Re: converting an oracle procedure to postgres	Tom Lane	22:32

Oct. 21, 2003

Thread	Author	Time
assorted Postgres SQL/ORDBMS questions	Clint Stotesbery	01:40
Re: assorted Postgres SQL/ORDBMS questions	Josh Berkus	02:47
Re: assorted Postgres SQL/ORDBMS questions	Tom Lane	03:59
Re: Alias-Error	Jost Richstein	07:17
Writing the SQL queries inside Functions and operators	Dharan	07:34
Many joins: monthly summaries S-L--O--W	Michael Glaesmann	12:09
function problem	geraldo	12:25
how to create a multi columns return function ?	jclaudio	13:08
plpgsql related question: intervals and variables	Wilhelm Graiss	13:58
Re: Fw: Max input parameter for a function	Josh Berkus	16:33
Re: Many joins: monthly summaries S-L--O--W	Josh Berkus	16:48
[postgres] Re: Deutsche PostgreSQL-Mailingliste unter postgresql.org	Peter Eisentraut	16:48
Re: Many joins: monthly summaries S-L--O--W	Tom Lane	17:27
Re: how to create a multi columns return function ?	Adam Witney	18:42
Re: plpgsql related question: intervals and variables	Josh Berkus	18:43
Re: plpgsql related question: intervals and variables	Richard Huxton	18:54
Re: how to create a multi columns return function ?	Richard Huxton	18:57
Re: Writing the SQL queries inside Functions and operators	Richard Huxton	18:59
Re: [SQL] Alias-Error	Richard Huxton	19:02
Re: function problem	Tom Lane	19:08
Re: plpgsql related question: intervals and variables	Stephan Szabo	21:39

Oct. 22, 2003

Thread	Author	Time
Timestamp	Abdul Wahab Dahalan	08:02
Re: Timestamp	Tomasz Myrta	08:18
Re: Alias-Error	Csaba Nagy	08:18
Re: Timestamp	achill	08:39
see a current query	sad	09:26
Re: Timestamp	Theodore Petrosky	11:40
Re: see a current query	Rod Taylor	12:36
Query planner: current_* vs. explicit date	Chris Gamache	13:25
Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Michael Glaesmann	17:07
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Tom Lane	17:44
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Josh Berkus	17:53
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Michael Glaesmann	18:34
Re: Query planner: current_* vs. explicit date	scott.marlowe	19:12
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Tom Lane	19:17
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Josh Berkus	19:20
Re: Expressional Indexes	Josh Berkus	19:39
Re: Expressional Indexes	Tom Lane	19:44
Re: Expressional Indexes	Josh Berkus	20:22
Re: Query planner: current_* vs. explicit date	Josh Berkus	20:25
Re: Expressional Indexes	Bruce Momjian	20:37
A tricky sql-query...	Timo	21:58
Re: Expressional Indexes	Peter Eisentraut	22:01
Re: Query planner: current_* vs. explicit date	Tom Lane	22:45

Oct. 23, 2003

Thread	Author	Time
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Michael Glaesmann	00:32
Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Josh Berkus	00:55
Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)	Tom Lane	02:53
List table with same column name	Abdul Wahab Dahalan	07:46
Re: List table with same column name	achill	08:31
Re: List table with same column name	Peter Childs	08:40
Re: List table with same column name	achill	09:08
Re: List table with same column name	Peter Childs	09:09
Error message during compressed backup	Senthil Kumar S	09:19
Re: List table with same column name	Achilleus Mantzios	09:57
Fw: Error message during compressed backup	Kumar	09:57
Re: Fw: Error message during compressed backup	Richard Huxton	11:25
Left outer join and sub queries alias	ext-thierry.templier	11:37
Re: Left outer join and sub queries alias	Richard Huxton	12:18
Re: Query planner: current_* vs. explicit date	Chris Gamache	15:29
Re: Réf. : Re: [SQL] Left outer join	Richard Huxton	15:35
Regular expression problem	Matias Surdi	18:12
Query Help using Except	yusuf0478	18:17
Query Help	yusuf0478	18:33
Re: Query Help	scott.marlowe	18:34
help on update subselect with joins	Jeff Kowalczyk	19:33
Re: Query Help	yusuf0478	19:44
Re: Regular expression problem	Manuel Sugawara	19:44
naming conventions constraint	Julian North	20:30
extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax	Alexander Vlasenko	21:00

Oct. 24, 2003

Thread	Author	Time
Re: Error message during compressed backup	Peter Eisentraut	12:31
Re: Regular expression problem	scott.marlowe	16:37
Re: Regular expression problem	Manuel Sugawara	17:04
Re: Regular expression problem	scott.marlowe	17:44
Re: naming conventions constraint	Rod Taylor	18:01

Browse Archives

Prev | Next