pgsql-sql since 2003-01-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
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. 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
Re: Could someone help me fix my array_list function? Joe Conway 01:45
Re: performance question Vernon Wu 05:32
returning setof in plpgsql David Durst 10:40
Speed depending of Join Order. Raúl Gutiérrez Sánchez 11:52
[OT] Unsubscribe does not work Andreas Tille 13:23
Re: [OT] Unsubscribe does not work Bruno Wolff III 14:13
Re: [OT] Unsubscribe does not work Andreas Tille 14:28
Re: returning setof in plpgsql Gary Stainburn 14:56
Re: [OT] Unsubscribe does not work Tom Lane 15:10
Re: Speed depending of Join Order. Tom Lane 15:14
Re: returning setof in plpgsql Tom Lane 15:34
[No subject] Bruce Becker 19:59
help Rudi Starcevic 22:44
Oops - help error. Rudi Starcevic 22:50

Jan. 22, 2003

Thread Author Time
optimal sql Michael Hostbaek 08:54
Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index Ludwig Lim 09:53
Re: optimal sql Tomasz Myrta 10:02
Re: optimal sql Michael Paesold 10:03
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index David Durst 10:11
Re: optimal sql Michael Hostbaek 10:14
Re: optimal sql Tomasz Myrta 10:50
PostgreSQL + SSL Pedro Igor Craveiro e Silva 11:59
Re: optimal sql Achilleus Mantzios 13:41
Re: optimal sql Achilleus Mantzios 14:50
To use a VIEW or not to use a View..... Ries van Twisk 15:12
Re: To use a VIEW or not to use a View..... Tomasz Myrta 15:46
Re: To use a VIEW or not to use a View..... Jan Wieck 15:46
Re: To use a VIEW or not to use a View..... Bruno Wolff III 15:48
Re: To use a VIEW or not to use a View..... Stephan Szabo 16:10
Re: To use a VIEW or not to use a View..... Tomasz Myrta 16:20
Re: To use a VIEW or not to use a View..... Stephan Szabo 17:09
Re: To use a VIEW or not to use a View..... Jan Wieck 17:30
Re: To use a VIEW or not to use a View..... Tomasz Myrta 18:38
Re: To use a VIEW or not to use a View..... Tomasz Myrta 18:55
Re: Speed depending of Join Order. Tom Lane 20:24
Re: To use a VIEW or not to use a View..... Stephan Szabo 21:09
Re: To use a VIEW or not to use a View..... Tom Lane 21:35
Re: sort by relevance Björn Metzdorf 21:43
Re: To use a VIEW or not to use a View..... Tomasz Myrta 21:54

Jan. 23, 2003

Thread Author Time
Re: To use a VIEW or not to use a View..... Stephan Szabo 00:45
Re: To use a VIEW or not to use a View..... Stephan Szabo 00:52
Re: To use a VIEW or not to use a View..... Tom Lane 01:01
DBCC CheckIdent in a stored proc? smoghe 01:14
Re: CREATE VIEW ERROR Igor 05:00
Re: To use a VIEW or not to use a View..... Ries van Twisk 08:08
Re: PostgreSQL + SSL Bhuvan A 10:14
Re: DBCC CheckIdent in a stored proc? Bhuvan A 10:17
Re: To use a VIEW or not to use a View..... Tomasz Myrta 10:49
calling function from rule Tambet Matiisen 10:51
Slow query Ricardo Javier Aranibar León 14:16
Re: Slow query Tomasz Myrta 14:43
Re: calling function from rule Tom Lane 15:30
Re: calling function from rule Tambet Matiisen 15:55
Re: To use a VIEW or not to use a View..... Stephan Szabo 16:53
Re: calling function from rule Tom Lane 17:00
Re: To use a VIEW or not to use a View..... Tom Lane 17:21

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