pgsql-sql - December 2003

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 22 23 24 25 26 27 29 30 31

Dec. 1, 2003

Thread Author Time
Re: Bug: Sequence generator insert Iain 02:27
Re: Bug: Sequence generator insert Iain 03:08
ECPG and User-defined Types. Andre Yoshiaki Kashiwabara 04:09
Ooops ! :( Recovery techniques Richard Sydney-Smith 04:41
Concatenating multiple fetches into a single string Kumar 12:01
Re: Concatenating multiple fetches into a single string Tomasz Myrta 20:01
Re: Permissions problem on 7.4 Peter Eisentraut 20:48
XML & Postgres Functions zerobearing2 22:17

Dec. 2, 2003

Thread Author Time
Re: Concatenating multiple fetches into a single string Kumar 04:51
Problem with intervals Bob Smith 05:09
Re: Concatenating multiple fetches into a single string Tomasz Myrta 06:07
Re: Problem with intervals Richard Huxton 08:56
Re: Validity check in to_date? Karel Zak 09:57
Re: Validity check in to_date? CoL 10:17
Re: XML & Postgres Functions CoL 10:20
Re: Validity check in to_date? Christoph Haller 10:27
Re: Validity check in to_date? Alexander M. Pravking 10:30
Re: Validity check in to_date? Alexander M. Pravking 10:36
Re: Validity check in to_date? Iain 10:44
Re: Validity check in to_date? Alexander M. Pravking 10:55
Re: Validity check in to_date? Alexander M. Pravking 10:58
Re: Problem with intervals Alexander M. Pravking 11:53
Re: Problem with intervals Tom Lane 14:51
Re: Validity check in to_date? Stephan Szabo 16:15
Re: Ooops ! :( Recovery techniques Christoph Haller 16:25
Re: Problem with intervals Bob Smith 20:55
[postgres] Text zu bytea casten Alvar Freude 23:07
Datatype Inet and Searching Devin Atencio 23:50

Dec. 3, 2003

Thread Author Time
Re: Validity check in to_date? Iain 02:18
relationship/table design question Taylor Lewick 02:45
Re: Updating session id based on accesstimeout greg 02:57
What's wrong with COPY rights in 7.3.4? Olivier Hubaut 15:59
Create Trigger porting problem from Oracle to PostgreSQL7.3.2 Doris Bernloehr 16:57
Re: Create Trigger porting problem from Oracle to PostgreSQL7.3.2 Clint Stotesbery 17:26
Re: Datatype Inet and Searching Gaetano Mendola 18:02
Re: Datatype Inet and Searching Guy Fraser 18:32
Help converting Oracle instead of triggers to PostgreSQL Clint Stotesbery 19:34

Dec. 4, 2003

Thread Author Time
Re: Help converting Oracle instead of triggers to PostgreSQL Christoph Haller 17:16
Re: Help converting Oracle instead of triggers to PostgreSQL Clint Stotesbery 17:52
How do I convert an interval into integer? Wei Weng 18:09
Trigger plpgsql function, how to test if OLD is set? Jeff Kowalczyk 18:18
Re: How do I convert an interval into integer? Tomasz Myrta 18:26
Re: Trigger plpgsql function, how to test if OLD is set? Tomasz Myrta 18:36
Re: Trigger plpgsql function, how to test if OLD is set? Jeff Kowalczyk 19:24
How Do I Toggle Quoted Identifiers? Google Mike 19:42
Re: How Do I Toggle Quoted Identifiers? Richard Huxton 20:45
Re: How Do I Toggle Quoted Identifiers? Peter Eisentraut 20:54
Re: relationship/table design question Jamie Lawrence 21:17

Dec. 5, 2003

Thread Author Time
Problem with dynamic query Kumar 12:43
Re: Problem with dynamic query Tomasz Myrta 13:02
Is it possible to set a NOT NULL constraint deferrable? Olivier Hubaut 15:47
Values like '' 📎 Elielson Fontanezi 19:18
Fetch a single record David Shadovitz 21:51

Dec. 6, 2003

Thread Author Time
Index not recognized Grace C. Unson 05:05
Re: What's wrong with COPY rights in 7.3.4? Bruce Momjian 12:27
Re: Help converting Oracle instead of triggers to PostgreSQL Robert Treat 23:45
Re: Is it possible to set a NOT NULL constraint deferrable? Bruce Momjian 23:54

Dec. 7, 2003

Thread Author Time
Re: Index not recognized Greg Stark 00:36
How to specify the beginning of the month in Postgres SQL syntax? jeff 16:16
Re: How to specify the beginning of the month in Postgres SQL syntax? CoL 19:38

Dec. 8, 2003

Thread Author Time
Field Size Ganesan Kanavathy 12:52
Re: Field Size Ganesan Kanavathy 12:56
Re: Field Size Marc A. Leith 13:03
Re: Field Size Somasekhar Bangalore 13:06
Re: Field Size Bruno Wolff III 15:35
postgresql and ColdFusion viola 23:23

Dec. 9, 2003

Thread Author Time
postgresql and ColdFusion viola 01:38
Re: postgresql and ColdFusion Roberto Mello 04:31
Re: postgresql and ColdFusion Benoît BOURNON 08:18
Re: postgresql and ColdFusion BenLaKnet 08:20
Re: Index not recognized Ace 08:37
Re: Values like '' Peter Eisentraut 19:49
Re: Fetch a single record Peter Eisentraut 20:21
Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this?? David B 21:35
Re: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this?? Peter Eisentraut 21:45
Re: Values like '' Stephan Szabo 21:51

Dec. 10, 2003

Thread Author Time
Re: Fetch a single record Paul Thomas 00:11
Re: Fetch a single record greg 00:45
Re: How to specify the beginning of the month in Postgres SQL syntax? Paul Thomas 00:52
Re: How to specify the beginning of the month in Postgres SQL syntax? sqllist 05:31
Bug in JDBC CREATE FUNCTION syntax? Olivier Hubaut 08:58
Re: Bug in JDBC CREATE FUNCTION syntax? Olivier Hubaut 09:17
How to completely move a table to another schema? Chris Travers 12:21
first of month DHS Webmaster 14:20
Re: How to specify the beginning of the month in Postgres SQL syntax? Tom Lane 15:51
Re: How to completely move a table to another schema? Tom Lane 16:12
picking max from list Jodi Kanter 20:37
Re: picking max from list Bruno Wolff III 20:53
Re: picking max from list Guy Fraser 23:11

Dec. 11, 2003

Thread Author Time
Using chkpass() in a query Michael A Nachbaur 18:34
simple LEFT JOIN giving wrong results ... Marc G. Fournier 21:01
Re: simple LEFT JOIN giving wrong results ... Tom Lane 22:16
Re: simple LEFT JOIN giving wrong results ... Marc G. Fournier 23:54

Dec. 12, 2003

Thread Author Time
Re: simple LEFT JOIN giving wrong results ... Stephan Szabo 00:47
Skip dups on INSERT instead of generating an error ... Marc G. Fournier 20:53
Re: Skip dups on INSERT instead of generating an error ... scott.marlowe 21:02
Re: Skip dups on INSERT instead of generating an error ... scott.marlowe 21:03
Re: Skip dups on INSERT instead of generating an error ... Tomasz Myrta 21:33

Dec. 13, 2003

Thread Author Time
Interest IN problem on 7.4 pginfo 07:10
Re: Help converting Oracle instead of triggers to PostgreSQL Robert Treat 14:55
Re: Interest IN problem on 7.4 Stephan Szabo 19:00
INHERITS and Foreign keys Henning.Baldersheim@devoll.no 19:43
Re: INHERITS and Foreign keys Stephan Szabo 19:55
Re: INHERITS and Foreign keys Henning.Baldersheim@devoll.no 21:07

Dec. 14, 2003

Thread Author Time
arrays in pl/pgsql Michael Shapiro 09:52

Dec. 15, 2003

Thread Author Time
dump and schema van Elsacker Frans 15:33
Re: Interest IN problem on 7.4 pginfo 15:53
Re: dump and schema Tom Lane 16:22
NOT-IN CLAUSE 📎 Prashant Dalal 17:14
Re: NOT-IN CLAUSE Bruno Wolff III 19:28

Dec. 16, 2003

Thread Author Time
Re: arrays in pl/pgsql Tom Lane 03:55
Re: dump and schema Olivier Hubaut 09:27
failed to build any 5-way joins Alessandro Depase 11:46
Re: dump and schema Peter Eisentraut 13:28
Pgaccess problem vijaykumar M 13:29
Re: failed to build any 5-way joins Peter Eisentraut 13:30
Re: dump and schema Tom Lane 14:17
Re: failed to build any 5-way joins Tom Lane 14:22
Re: Pgaccess problem Paul Thomas 14:46
Re: Pgaccess problem Richard Huxton 14:57
Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys Jason L. van Brackel 15:24
Re: failed to build any 5-way joins Alessandro Depase 15:34
Re: failed to build any 5-way joins Richard Huxton 16:12
Re: failed to build any 5-way joins Alessandro Depase 16:23
Problem with functions. Jonas Lindholm 18:55

Dec. 17, 2003

Thread Author Time
SQL Optimization Preeti Ambardar 06:26
Re: failed to build any 5-way joins Tom Lane 15:32
Re: failed to build any 5-way joins Alessandro Depase 16:04
migration between databases and versions mohan 18:58

Dec. 18, 2003

Thread Author Time
Re: migration between databases and versions Iain 01:30
Re: migration between databases and versions A.Bhuvaneswaran 09:40
how do i get differences between rows teknokrat 12:21
Returning Setof Record Dynamically A E 18:20

Dec. 19, 2003

Thread Author Time
INDEX and NULL values Matthew Rudolph 00:23
Crosstable query Dok, D. van 14:41
how to preserve \n in select statement Matt Van Mater 15:06
testing for null value in integer field? Geoffrey 16:07
Re: testing for null value in integer field? CoL 16:08
Re: testing for null value in integer field? Wei Weng 16:12
Re: testing for null value in integer field? Guy Fraser 16:16
Re: testing for null value in integer field? Geoffrey 16:22
Re: how to preserve \n in select statement Matt Van Mater 18:29
Re: how to preserve \n in select statement Bruno Wolff III 21:26
Re: INHERITS and Foreign keys Pedro 23:51

Dec. 20, 2003

Thread Author Time
Re: how to preserve \n in select statement Matt Van Mater 04:23
Re: how to preserve \n in select statement Tom Lane 04:45
Re: how to preserve \n in select statement Matt Van Mater 17:58
Re: how to preserve \n in select statement Tom Lane 18:35

Dec. 22, 2003

Thread Author Time
Get x from point? Daniel Lau 08:54
Re: how to preserve \n in select statement Richard Huxton 09:04
Re: how to preserve \n in select statement Denis 09:37
[No subject] sundaresan raman 10:30
Re: how to preserve \n in select statement Richard Huxton 10:48
Re: Get x from point? Michael Fuhr 10:53
restoring database LAIN Lucas TECHTEL 14:58
restoring database Lucas Lain 14:58
Re: restoring database Theodore Petrosky 16:43
Re: restoring database scott.marlowe 17:53
Re: Insert Row to ResultSet Dave Cramer 19:32
Re: Crosstable query Michael Glaesemann 22:32
Re: SQL Optimization Tom Lane 23:07
Re: [JDBC] Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys Paul Thomas 23:50

Dec. 23, 2003

Thread Author Time
Re: A.Bhuvaneswaran 05:22
Pgaccess problem on RedhatLinux9 vijaykumar M 05:49
Re: Pgaccess problem on RedhatLinux9 Richard Huxton 09:22
stored queries Joop 09:25
Re: restoring database Markus Bertheau 10:18
Re: INHERITS and Foreign keys Chris Travers 13:13
Re: how do i get differences between rows teknokrat 13:23
Historic Query using a view/function ? Chris Gamache 16:46
Distributed keys Michael Glaesemann 21:42
Re: Distributed keys Tom Lane 23:39

Dec. 24, 2003

Thread Author Time
Re: how do i get differences between rows Bruno Wolff III 03:31
Re: how to preserve \n in select statement Iain 03:56
MD5 encrypt alvaro 16:47

Dec. 25, 2003

Thread Author Time
Use of Setof Record Dynamically A E 00:17
not in vs not exists - vastly diferent performance Iain 01:50
Re: Distributed keys Chris Travers 02:45
Point and function help Andy Lewis 07:05
Re: not in vs not exists - vastly diferent performance Tom Lane 16:32
Re: Point and function help Tom Lane 16:43
Re: Point and function help Andy Lewis 18:39

Dec. 26, 2003

Thread Author Time
Multiple DB servers on a single machine Kumar 06:32
Re: Multiple DB servers on a single machine A.Bhuvaneswaran 09:31
Anti log in PostgreSQL Sai Hertz And Control Systems 22:12
Re: Anti log in PostgreSQL Martin Marques 22:34
Re: [SQL] Anti log in PostgreSQL Sai Hertz And Control Systems 22:46
Re: Anti log in PostgreSQL Wei Weng 22:53
Re: Anti log in PostgreSQL Yasir Malik 23:18
Re: Anti log in PostgreSQL Martin Marques 23:20
Re: Anti log in PostgreSQL Sai Hertz And Control Systems 23:25
Re: Anti log in PostgreSQL Tom Lane 23:37
Radius of a zip code Andy Lewis 23:42

Dec. 27, 2003

Thread Author Time
Re: Radius of a zip code Tom Lane 00:09
Re: Anti log in PostgreSQL Chris Travers 02:14
Re: [SQL] Anti log in PostgreSQL David F. Skoll 02:34
Re: Radius of a zip code Michael Fuhr 02:42
Re: Radius of a zip code Joe Conway 03:08
Re: MD5 encrypt Michael Fuhr 03:53
Re: Radius of a zip code Bruno Wolff III 04:34

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 22 23 24 25 26 27 29 30 31