pgsql-sql since 2002-07-07 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

July 7, 2002

Thread	Author	Time
Re: bit field changes in 7.2.1	Peter Eisentraut	10:59
Re: Localization	Peter Eisentraut	10:59
Re: Can this be done with sql?	Rajesh Kumar Mallah.	13:36
Re: Is Dropping a column "CHECK" constraint possible?	Rajesh Kumar Mallah.	13:45
manipulating the database in plsql	teknokrat	18:40
Bad SUM result	Roy Souther	20:25
Re: Bad SUM result	Stephan Szabo	20:44
newbie question	Mirco D'Angelo	21:59

July 8, 2002

Thread	Author	Time
INSERT only under certain conditions (SELECT)	Joachim Trinkwitz	01:18
[No subject]	jack	08:11
Re: INSERT only under certain conditions (SELECT)	Rajesh Kumar Mallah.	08:12
Double quotes?	Archibald Zimonyi	10:35
Re: Double quotes?	Archibald Zimonyi	10:58
Re: INSERT only under certain conditions (SELECT)	Bruno Wolff III	12:40
Re: Double quotes?	Christoph Haller	12:54
Variables in PSQL	Roger Mathis	13:24
is there a way to get hh:mm:ss given seconds	Narendra A	14:28
Re: bit field changes in 7.2.1	Kevin Brannen	15:10
Re: Bad SUM result	Jean-Luc Lachance	15:22
Re: INSERT only under certain conditions (SELECT)	Joachim Trinkwitz	15:49
Re: manipulating the database in plsql	Roberto Mello	15:51
Re: newbie question	Roberto Mello	15:53
Re: manipulating the database in plsql	Janning Vygen	16:36
Re: newbie question	Richard Huxton	16:49
Rule WHERE condition problem	Kristian Eide	17:45
Re:	Bruce Momjian	18:40
Re: newbie question	Ignacio Coloma	20:28
PLPGSQL language documentation	Sandy Ear	22:45

July 9, 2002

Thread	Author	Time
Re: how to write procedures	Bhuvan A	04:40
Re: newbie question	Christopher Kings-Lynne	06:39
Re: newbie question	Achilleus Mantzios	06:45
Waiting for Update	JGM	07:04
SQL problem with aggregate functions.	David BOURIAUD	08:36
Re: INSERT only under certain conditions (SELECT)	Bruno Wolff III	12:18
Re: Rule WHERE condition problem	Jan Wieck	13:00
Re: Rule WHERE condition problem	Tom Lane	13:23
Re: Rule WHERE condition problem	Kristian Eide	13:41
Re: export plpgsql function to file	Achilleus Mantzios	14:30
Re: is there a way to get hh:mm:ss given seconds	Tod McQuillin	14:41
Re: is there a way to get hh:mm:ss given seconds	David Stanaway	14:58
Re: PLPGSQL language documentation	Bradley Kieser	17:10
Re: PLPGSQL language documentation	Josh Berkus	17:11
export plpgsql function to file	Joseph Syjuco	18:06
Re: PLPGSQL language documentation	Jeff Eckermann	19:02
Re: is there a way to get hh:mm:ss given seconds	Kevin Brannen	19:11
pg_restore cannot restore index	Jie Liang	19:44
Re: pg_restore cannot restore index	Jie Liang	21:00

July 10, 2002

Thread	Author	Time
Re: pg_restore cannot restore index 📎	Bruce Momjian	02:58
Re: is there a way to get hh:mm:ss given seconds	Josh Berkus	05:46
Re: is there a way to get hh:mm:ss given seconds	Christopher Kings-Lynne	05:49
Re: Bad SUM result	Petr Jezek	08:00
query/transaction history/logs	q	08:34
Re: query/transaction history/logs	David BOURIAUD	09:08
Help with function optimisation	Ian Cass	09:38
Error with DISTINCT and AS keywords	Andreas Schlegel	11:57
How to get total number of rows when using LIMIT/OFFSET?	Dirk Lutzebaeck	12:25
Re: Error with DISTINCT and AS keywords	Achilleus Mantzios	12:25
Re: Problem on PostgreSQL (error code, store procedures)	Christoph Haller	12:47
Re: Variables in PSQL	Christoph Haller	13:00
Re: Error with DISTINCT and AS keywords	Richard Huxton	13:31
Re: Help with function optimisation	Tom Lane	13:34
Re: Error with DISTINCT and AS keywords	Tom Lane	14:09
Re: Error with DISTINCT and AS keywords	Jean-Luc Lachance	15:22
Re: Waiting for Update	Jan Wieck	15:27
Re: pg_restore cannot restore index	Jie Liang	15:42
XML to Postgres conversion	Nathan Hill	16:24
BETWEEN bug?	Josh Berkus	19:35
Insert Function	David Durst	19:59
Re: BETWEEN bug?	Stephan Szabo	20:10
Re: Insert Function	Ian Barwick	20:45
Re: BETWEEN bug?	Josh Berkus	21:57

July 11, 2002

Thread	Author	Time
Returning rows from functions	David Durst	00:37
Re: How to get total number of rows when using LIMIT/OFFSET?	Bruce Momjian	01:50
Re: pg_restore cannot restore index	Bruce Momjian	02:05
Re: BETWEEN bug?	Josh Berkus	03:22
Re: Returning rows from functions	Joe Conway	04:59
Re: Insert Function	Ian Barwick	06:38
Re: SQL problem with aggregate functions.	Christoph Haller	10:37
list of tables ?	Steve Brett	14:00
Re: list of tables ? -update to question ...	Steve Brett	14:07
Re: list of tables ?	Ian Barwick	14:09
Re: list of tables ?	Achilleus Mantzios	14:09
Re: list of tables ?	Steve Brett	14:13
Re: XML to Postgres conversion	George.T.Essig	14:23
how to inherits the references...	frederik nietzsche	14:43
Re: [SQL] XML to Postgres conversion	Rudi Starcevic	15:18
please help on query	Luis Alberto Amigo Navarro	15:22
Re: pg_restore cannot restore index	Jie Liang	15:41
Re: how to inherits the references...	Stephan Szabo	16:00
Re: [HACKERS] please help on query	Manfred Koizar	16:47
Re: [HACKERS] please help on query	Luis Alberto Amigo Navarro	17:40
Re: please help on query	J. R. Nield	18:06
Re: please help on query	Andy Kopciuch	18:09
Re: list of tables ? -update to question ...	Jan Wieck	18:38
Re: [HACKERS] please help on query	Manfred Koizar	18:44
Re: pg_restore cannot restore index	Jie Liang	19:48
Re: please help on query	Hannu Krosing	20:48
Re: please help on query	Hannu Krosing	20:51
Re: please help on query	Hannu Krosing	21:08
Re: SQL problem with aggregate functions.	Loyd Goodbar	22:08
Please, HELP! Why is the query plan so wrong???	Dmitry Tkach	22:50
Re: [SQL] Please, HELP! Why is the query plan so wrong???	Jie Liang	23:26
PostgreSQL - contrib/xml	Rudi Starcevic	23:27

July 12, 2002

Thread	Author	Time
Re: PostgreSQL - contrib/xml	Christopher Kings-Lynne	01:39
Query kill	Rudi Starcevic	05:00
Re: Query kill	Bruce Momjian	05:01
rules / triggers on insert. why after?	Ahti Legonkov	09:24
Re: how to inherits the references...	frederik nietzsche	10:29
Re: [HACKERS] please help on query	Luis Alberto Amigo Navarro	11:37
Re: [HACKERS] please help on query	Jakub Ouhrabka	11:50
Re: [HACKERS] please help on query	Jakub Ouhrabka	11:52
Re: rules / triggers on insert. why after?	Jan Wieck	13:41
Re: how to inherits the references...	Stephan Szabo	14:03
Re: list of tables ?	Christoph Haller	14:16
Re: SQL problem with aggregate functions.	Jean-Luc Lachance	14:28
Re: [SQL] Please, HELP! Why is the query plan so wrong???	Dmitry Tkach	14:34
Re: rules / triggers on insert. why after?	Tom Lane	15:07
Re: [SQL] Please, HELP! Why is the query plan so wrong???	Jie Liang	15:29
config postgresql.conf??	Jie Liang	15:32
Re: [HACKERS] please help on query	Luis Alberto Amigo Navarro	15:32
Re: config postgresql.conf??	Josh Berkus	15:56
It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???)	Dmitry Tkach	16:17
Re: Query kill	eric soroos	17:22
Re: Query kill	Jan Wieck	17:53

July 13, 2002

Thread	Author	Time
Re: XML to Postgres conversion	Marc Spitzer	02:00
Re: Query kill	Bruce Momjian	02:13
Re: Query kill	Jan Wieck	03:55
Re: Query kill	Bruce Momjian	04:27
Indexes with LIKE	Julian Scarfe	09:53
Re: pg_restore cannot restore index 📎	Bruce Momjian	14:50
Re: Indexes with LIKE	Stephan Szabo	15:28
Re: Indexes with LIKE	Julian Scarfe	18:18
Re: It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???)	Tom Lane	19:27
sql question:	Chris Aiello	22:24

July 14, 2002

Thread	Author	Time
Re: sql question:	Ahti Legonkov	02:38
line datatype	Tim Hart	05:09
Re: [HACKERS] please help on query	Masaru Sugawara	12:23
Re: Indexes with LIKE	Stephan Szabo	19:46

July 15, 2002

Thread	Author	Time
Quick Question	Christopher Kings-Lynne	03:15
Sorry..	Christopher Kings-Lynne	03:17
Re: Sorry..	Tom Lane	03:27
Fwd: line datatype	Tim Hart	03:32
Re: [HACKERS] please help on query	Luis Alberto Amigo Navarro	07:45
Re: line datatype	Bruce Momjian	14:43
Re: pg_restore cannot restore index	Jie Liang	14:46
Re: [HACKERS] please help on query	Masaru Sugawara	16:15
[No subject]	Wallingford, Ted	17:45
Re: [SQL]	Bruce Momjian	17:51
Seeding	Chad Thompson	18:45
Indexing UNIONs	Josh Berkus	19:00
Re: Indexing UNIONs	Stephan Szabo	20:12
Re: Sorry..	Josh Berkus	21:01
Re: pg_restore cannot restore index	Bruce Momjian	22:23
Re: [SQL] Seeding	Peter Eisentraut	22:54
Re: pg_restore cannot restore index	Jie Liang	23:22
Re: pg_restore cannot restore index	Bruce Momjian	23:24
how pg_restore long form works?	Jie Liang	23:24
pg_restore --flag	Jie Liang	23:39

July 16, 2002

Thread	Author	Time
Re: Indexing UNIONs	Josh Berkus	00:31
Re: Indexing UNIONs	Stephan Szabo	00:42
Re: line datatype	Bruce Momjian	03:33
Re: [SQL] line datatype	Thomas Lockhart	06:10
How do I concatenate row-wise instead of column-wise?	Marcus Claesson	08:09
Re: [HACKERS] please help on query	Luis Alberto Amigo Navarro	08:51
Re: How do I concatenate row-wise instead of column-wise?	Richard Huxton	09:15
Cascading deletions does not seem to work inside PL/PGSQL functions. 📎	Rajesh Kumar Mallah.	11:25
Re: How do I concatenate row-wise instead of column-wise?	Rajesh Kumar Mallah.	11:34
Re: Indexing UNIONs	Bruno Wolff III	11:45
Re: [SQL] line datatype	Tom Lane	13:44
Re: [SQL] line datatype	Bruce Momjian	15:21
Re: [SQL] line datatype	Thomas Lockhart	15:29
Re: [SQL] line datatype	Bruce Momjian	15:38
Re: [SQL] line datatype	Thomas Lockhart	16:07
Re: [SQL] line datatype	Lamar Owen	16:10
Re: Cascading deletions does not seem to work inside PL/PGSQL	Stephan Szabo	16:11
Re: [SQL] line datatype	Bruce Momjian	16:26
Re: [SQL] line datatype	Tom Lane	16:30
Re: [SQL] line datatype	Bruce Momjian	16:31
Re: Indexing UNIONs	Josh Berkus	16:36
A SQL Training	Devrim GUNDUZ	17:18
Need help on a troublesome query plan	Alain Lavigne	17:24
Re: Seeding	Chad Thompson	17:31
datatype matrix (was: Re: Sorry..)	Kevin Brannen	17:37
Re: A SQL Training	Josh Berkus	18:07
Re: Seeding	Ron Johnson	18:38
Re: Need help on a troublesome query plan	Stephan Szabo	18:52
Re: Need help on a troublesome query plan	Alain Lavigne	19:02
Re: Indexing UNIONs	Bruno Wolff III	19:20
Re: Seeding	Chad Thompson	19:38
Re: Need help on a troublesome query plan	Stephan Szabo	20:31
Re: [SQL] line datatype	Thomas Lockhart	20:42
Re: [SQL] line datatype	Lamar Owen	20:46
Re: datatype matrix (was: Re: Sorry..)	Josh Berkus	22:34
Re: Indexing UNIONs	Josh Berkus	22:42

July 17, 2002

Thread	Author	Time
Newbie: Creative use of LIMIT??	Shmuel A. Kahn	02:20
Sequence name length	Rudi Starcevic	02:38
Re: Sequence name length	Christopher Kings-Lynne	02:49
Re: Sequence name length	Tom Lane	03:40
Re: Sequence name length	Christopher Kings-Lynne	03:45
Re: Sequence name length	Rudi Starcevic	03:51

Browse Archives

Prev | Next