pgsql-sql since 2003-01-09 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
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

Jan. 9, 2003

Thread Author Time
Re: What benefits can I expect from schemas ? chester c young 02:20
Re: What benefits can I expect from schemas ? Bruce Momjian 02:26
Postgresql Bug List? Wei Weng 04:11
Postgresql Bug List? Wei Weng 04:22
Re: Postgresql Bug List? Bruce Momjian 04:30
Re: Search and Replace Rajesh Kumar Mallah. 05:30
Returning row or rows from function? David Durst 06:21
switching default integer datatype to int8 and "IN (...)" clause postgres 09:24
Re: switching default integer datatype to int8 and "IN (...)" clause Andrew J. Kopciuch 10:30
Re: PostgreSQL X Resin EE Radu-Adrian Popescu 10:42
SQL function parse error ? Radu-Adrian Popescu 11:14
Re: SQL function parse error ? Tomasz Myrta 11:56
Re: SQL function parse error ? Radu-Adrian Popescu 12:43
http://www.postgresql.org site problem Achilleus Mantzios 12:45
Re: SQL function parse error ? Tomasz Myrta 13:22
Re: Postgresql Bug List? Robert Treat 14:18
Re: SQL function parse error ? Tom Lane 14:48
Re: SQL function parse error ? Radu-Adrian Popescu 15:05
Re: SQL function parse error ? Radu-Adrian Popescu 15:22
Re: SQL function parse error ? Radu-Adrian Popescu 15:38
Re: SQL function parse error ? Stephan Szabo 15:47
Re: SQL function parse error ? Tom Lane 15:57
Re: SQL function parse error ? Radu-Adrian Popescu 16:29
Re: SQL function parse error ? Stephan Szabo 17:00
Re: SQL function parse error ? Tom Lane 17:17
Re: SQL function parse error ? Radu-Adrian Popescu 17:37
Re: insert rule doesn't see id field Ron Peterson 19:12
Re: SQL function parse error ? Achilleus Mantzios 19:29
Re: insert rule doesn't see id field dev 19:54
Re: SQL function parse error ? Robert Treat 20:44
Re: insert rule doesn't see id field Ron Peterson 21:50
Re: Search and Replace Ross J. Reedstrom 23:03

Jan. 10, 2003

Thread Author Time
Re: [SQL] Search and Replace Randy D. McCracken 00:15
Re: [SQL] Search and Replace Bruno Wolff III 00:38
Getting sequence value after inserting many rows at a time Maurício Sessue Otta 00:48
Re: Getting sequence value after inserting many rows at a time Bruno Wolff III 01:25
Re: insert rule doesn't see id field Ron Peterson 02:07
Re: insert rule doesn't see id field Tom Lane 04:53
Table Design Questions Chad L 09:08
Re: SQL function parse error ? Radu-Adrian Popescu 09:13
Re: insert rule doesn't see id field Radu-Adrian Popescu 09:31
Re: insert rule doesn't see id field Radu-Adrian Popescu 09:33
Re: SQL function parse error ? Robert Treat 14:26
Re: SQL function parse error ? Tom Lane 14:48
Re: Table Design Questions dev 15:12
Re: insert rule doesn't see id field Ron Peterson 16:27
Re: Table Design Questions Josh Berkus 17:32
Re: noupcol code cleanup Ron Peterson 18:46
function does not exist Dave A. 22:22
Re: function does not exist Ross J. Reedstrom 22:23
Re: function does not exist Josh Berkus 22:26
Select * from users WHERE upper(lastName) = upper('Pringle') Hale Pringle 23:45

Jan. 11, 2003

Thread Author Time
Re: Getting sequence value after inserting many rows at a time Bruno Wolff III 18:45

Jan. 12, 2003

Thread Author Time
Re: switching default integer datatype to int8 and "IN (...)" postgres 00:03
Re: Select * from users WHERE upper(lastName) = Dave Cramer 00:28
Re: Select * from users WHERE upper(lastName) = upper('Pringle') Tom Lane 04:45

Jan. 13, 2003

Thread Author Time
Unique indexes not unique? Jimmy Mäkelä 10:05
Re: Unique indexes not unique? Tomasz Myrta 10:43
Re: Unique indexes not unique? Jimmy Mäkelä 10:56
Re: Unique indexes not unique? Stephan Szabo 12:08
Re: Unique indexes not unique? dev 12:32
Crosstab-style query in pure SQL dev 12:47
Re: Unique indexes not unique? Tom Lane 15:31
Re: Unique indexes not unique? Stephan Szabo 15:58
Re: Unique indexes not unique? Tom Lane 16:12
Re: Crosstab-style query in pure SQL Josh Berkus 17:26
Re: Returning row or rows from function? Stephan Szabo 18:43
Re: to_date confusion Stephan Szabo 18:45
Re: to_date confusion Josh Berkus 18:45
Re: Returning row or rows from function? Tomasz Myrta 18:48
Re: Crosstab-style query in pure SQL dev 19:30
Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. Chris Travers 20:18
assigning values to array elements J Greenbaum 20:25
Re: assigning values to array elements Tom Lane 21:04
Re: assigning values to array elements J Greenbaum 21:11
query speed joining tables Christopher Smith 21:20
Re: query speed joining tables Josh Berkus 21:47
Re: query speed joining tables Christopher Smith 21:56
Re: query speed joining tables Tomasz Myrta 22:01
Re: query speed joining tables Christopher Smith 22:03
Re: insert rule doesn't see id field Ron Peterson 22:11
Re: insert rule doesn't see id field Tom Lane 22:16
Re: Postgresql Bug List? Bruce Momjian 22:18

Jan. 14, 2003

Thread Author Time
Re: assigning values to array elements Bruce Momjian 00:47
Re: query speed joining tables Tomasz Myrta 07:12
Re: full join in view Tambet Matiisen 09:04
Re: full join in view Tomasz Myrta 09:50
Data between different databases Pedro Igor 10:53
Re: full join in view Tambet Matiisen 14:27
database broken ? [email protected] 14:45
Re: database broken ? Tom Lane 15:51
Re: Select * from users WHERE upper(lastName) = upper('Pringle') Andrew Sullivan 16:34
Re: query speed joining tables Josh Berkus 19:38
Re: RFC: A brief guide to nulls Josh Berkus 19:46
Re: full join in view jasiek 20:02

Jan. 15, 2003

Thread Author Time
sort by relevance Serhiy Levchenko 07:44
Re: full join in view Tambet Matiisen 09:25
Performance of request of type WHERE ... IN ( ... ) Th Templ 10:23
index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh 11:37
Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh 11:52
Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh 12:08
sort by relevance sector119 13:58
Oracle outer join porting question Marko Asplund 14:31
Re: Oracle outer join porting question Dan Langille 14:38
Re: Oracle outer join porting question Tambet Matiisen 14:40
Re: Performance of request of type WHERE ... IN ( ... ) Achilleus Mantzios 15:00
Re: Oracle outer join porting question Dan Langille 15:01
Re: index on to_char(created, 'YYYY') doesn't work Andreas Joseph Krogh 15:04
Re: index on to_char(created, 'YYYY') doesn't work Tom Lane 15:57
Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios 16:12
Re: Performance of request of type WHERE ... IN ( ... ) Josh Berkus 17:17
Re: index on to_char(created, 'YYYY') doesn't work Steve Crawford 17:19
RFC: A brief guide to nulls dev 17:23
Re: index on to_char(created, 'YYYY') doesn't work 📎 Andreas Joseph Krogh 17:38
Re: query speed joining tables Josh Berkus 17:50
Re: index on to_char(created, 'YYYY') doesn't work Josh Berkus 18:15
Re: [SQL] sort by relevance Oleg Bartunov 18:19
lost on self joins Matthew Nuzum 18:29
Re: A brief guide to nulls Otto Hirr 18:30
Re: query speed joining tables Vernon Wu 18:33
Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios 18:55
Re: RFC: A brief guide to nulls Andrew Perrin 19:18
Re: sub-select with aggregate Tom Lane 19:45
Re: RFC: A brief guide to nulls Antti Haapala 19:51
Re: lost on self joins Tomasz Myrta 19:59
Re: index on to_char(created, 'YYYY') doesn't work Achilleus Mantzios 20:02
Re: sort by relevance Ross J. Reedstrom 20:07
Re: lost on self joins Matthew Nuzum 20:19
Re: RFC: A brief guide to nulls Bruno Wolff III 20:41
Re: lost on self joins Bruno Wolff III 20:52
Re: RFC: A brief guide to nulls Antti Haapala 22:19
Re: lost on self joins Ross J. Reedstrom 22:54
Re: RFC: A brief guide to nulls Peter Eisentraut 23:44

Jan. 16, 2003

Thread Author Time
Re: lost on self joins Tomasz Myrta 00:04
show data from two tables together Matthew Nuzum 01:01
joining from multiple tables Joseph Shraibman 01:43
Re: RFC: A brief guide to nulls Ludwig Lim 01:59
Re: joining from multiple tables Stephan Szabo 02:02
Re: show data from two tables together Stephan Szabo 03:26
Re: show data from two tables together Matthew Nuzum 03:46
Re: RFC: A brief guide to nulls Tom Lane 04:20
pg_dump problem Rudi Starcevic 06:10
Re: sort by relevance sector119 06:30
Re: [SQL] sort by relevance Rajesh Kumar Mallah. 07:12
Re: RFC: A brief guide to nulls dev 09:07
Re: RFC: A brief guide to nulls dev 09:09
Re: RFC: A brief guide to nulls (noarchive) Ries van Twisk 10:01
Re: Oracle outer join porting question Marko Asplund 11:32
Implementing automatic updating of primary keys... Rajesh Kumar Mallah. 12:11
Re: Implementing automatic updating of primary keys... Rajesh Kumar Mallah. 14:28
Function unkown Pedro Igor 16:13
Re: RFC: A brief guide to nulls Otto Hirr 17:22
pg_restore cannot restore an index Jie Liang 17:39
Re: query speed joining tables Josh Berkus 17:46
Re: pg_restore cannot restore an index Bruce Momjian 18:07
Re: pg_restore cannot restore an index Tom Lane 18:34
Re: pg_restore cannot restore an index Jie Liang 22:21
Re: query speed joining tables Vernon Wu 23:22
Re: query speed joining tables Josh Berkus 23:42

Jan. 17, 2003

Thread Author Time
cannot create function that uses variable table name Matthew Nuzum 03:32
Re: cannot create function that uses variable table name chester c young 04:42
Re: cannot create function that uses variable table name Stephan Szabo 04:43
Re: cannot create function that uses variable table name D'Arcy J.M. Cain 09:48
sum(time) problem Oliver Vecernik 13:03
Re: sum(time) problem Julian Scarfe 13:13
Re: sum(time) problem Tom Lane 15:03
RCF: 2nd draft: A brief guide to Nulls dev 15:05
"Best practice" advice Andrew Perrin 20:06
Re: "Best practice" advice Josh Berkus 20:16
Re: double precision to numeric overflow error Jan Wieck 20:43
Can I do this? Wei Weng 23:51

Jan. 18, 2003

Thread Author Time
Re: Can I do this? Bruce Momjian 00:19
Re: Can I do this? Josh Berkus 00:31
Problem with COPY FROM Harry Yau 06:16

Jan. 19, 2003

Thread Author Time
Selecting a non-locked row. Kurt Roeckx 13:33
Re: Selecting a non-locked row. Josh Berkus 21:26
Re: Selecting a non-locked row. Kurt Roeckx 22:03
Re: Selecting a non-locked row. Josh Berkus 22:34
Group By Error Text Joseph Healy 22:36
Re: Group By Error Text Josh Berkus 22:46

Jan. 20, 2003

Thread Author Time
Re: Selecting a non-locked row. D'Arcy J.M. Cain 01:34
Re: cannot create function that uses variable table name Beth 03:17
Re: Function unkown Tomasz Myrta 07:28
Re: pg_dump problem Bhuvan A 09:37
Re: Implementing automatic updating of primary keys... Bhuvan A 09:55
performance question Moritz Lennert 11:40
performance question Moritz Lennert 11:40
Re: Unique indexes not unique? Jimmy Mäkelä 11:52
Re: performance question Manfred Koizar 15:13
Re: performance question Moritz Lennert 16:45
Re: performance question Moritz Lennert 17:10
Re: performance question Josh Berkus 18:08
Re: performance question Manfred Koizar 18:27
Could someone help me fix my array_list function? Guy Fraser 18:50
Re: performance question Moritz Lennert 19:34
Re: performance question Tom Lane 20:38
Re: performance question Tomasz Myrta 21:05
Re: performance question Josh Berkus 22:20
Re: Could someone help me fix my array_list function? Joe Conway 23:27

Jan. 21, 2003

Thread Author Time
Re: Could someone help me fix my array_list function? Michiel Lange 00:38

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