pgsql-sql since 2003-02-23 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

Feb. 23, 2003

Thread Author Time
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 00:14
sql question after upgrade James Cooper 00:58
Re: sql question after upgrade Neil Conway 01:42
Re: 7.3 "group by" issue Peter Eisentraut 02:24
Re: sql question after upgrade Peter Eisentraut 02:24
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 10:47
Porting from db2 problem Wayne Armstrong 11:11
Re: how to return ONE single record from a function in plpgsql? Tom Lane 16:34
Help with query involving aggregation and joining. Eddie Cheung 19:02
Re: inserting multiple rows with one statement codeWarrior 19:26
Re: 7.3 "group by" issue Josh Berkus 19:59
Re: [SQL] 7.3 GROUP BY differs from 7.2 Josh Berkus 20:19
Re: Help with query involving aggregation and joining. Josh Berkus 20:24
Re: Help with query involving aggregation and joining. Bruno Wolff III 20:45
syntax question James Cooper 22:07
SQL Statements question, why I get errors... plist 22:17
Re: syntax question Josh Berkus 22:52
Re: SQL Statements question, why I get errors... Josh Berkus 22:57
Re: syntax question Josh Berkus 23:07
Re: SQL Statements question, why I get errors... plist 23:13
Re: good style? Rafal Kedziorski 23:51

Feb. 24, 2003

Thread Author Time
Re: syntax question Josh Berkus 00:25
Re: SQL Statements question, why I get errors... Bruno Wolff III 03:27
Re: Help with query involving aggregation and joining. Eddie Cheung 05:17
Re: Help with query involving aggregation and joining. Eddie Cheung 05:18
Re: Help with query involving aggregation and joining. Josh Berkus 06:46
Re: Porting from db2 problem Christoph Haller 09:30
Re: Help with query involving aggregation and joining. Rajesh Kumar Mallah 13:24
Re: Help with query involving aggregation and joining. Christoph Haller 13:49
Re: syntax question Jeff Eckermann 15:17
Re: syntax question Tom Lane 15:30
Re: Help with query involving aggregation and joining. mallah 15:51
Re: Help with query involving aggregation and joining. Bruno Wolff III 17:16
Denormalizing during select no.spam 17:18
Dynamic SELECT condition Victor Yegorov 17:53
Re: syntax question Josh Berkus 18:22
Re: Denormalizing during select Jeff Boes 19:12
indexing James Cooper 20:38
Re: Denormalizing during select Josh Berkus 22:33
indexing James Cooper 22:38
Problem with deferred referential integrity checks Bob Smith 23:38

Feb. 25, 2003

Thread Author Time
Inquiry From Form [pgsql] Jack Kiss 00:22
Re: indexing Josh Berkus 01:16
Re: Denormalizing during select no.spam 03:37
Re: Denormalizing during select Edmund Lian 03:44
Sub Select inside Check ? Rudi Starcevic 05:48
Re: good style? Tambet Matiisen 06:42
two dates mixo 06:55
Re: Problem with deferred referential integrity checks Stephan Szabo 07:09
Re: Help with query involving aggregation and joining. Eddie Cheung 08:22
Re: good style? Rafal Kedziorski 08:44
Re: Sub Select inside Check ? Tomasz Myrta 11:29
STORAGE and GiST Itai Zukerman 14:06
Any limitation in size for return result from SELECT? Natasa Bulatovic 14:25
how can i drop a <unnamed> constraint rute solipa 14:55
Re: how can i drop a <unnamed> constraint Christoph Haller 15:05
Polymorphic? Itai Zukerman 15:09
Re: how can i drop a <unnamed> constraint Christoph Haller 15:23
Re: STORAGE and GiST Tom Lane 15:32
Re: Sub Select inside Check ? Stephan Szabo 15:50
Relation "pg_relcheck" Victor Yegorov 15:50
Re: Relation "pg_relcheck" Victor Yegorov 16:08
Re: Relation "pg_relcheck" Stephan Szabo 16:11
Re: Polymorphic? Tom Lane 16:20
Re: Relation "pg_relcheck" Ian Barwick 16:22
Re: Relation "pg_relcheck" Tom Lane 16:24
Re: Relation "pg_relcheck" Rod Taylor 16:34
Re: Denormalizing during select Josh Berkus 18:24
Re: Denormalizing during select Edmund Lian 18:48
Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 19:20
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Tom Lane 21:10
a change of query James Cooper 22:03
Re: a change of query Brad Hilton 22:39
Re: a change of query Chad Thompson 22:40
Re: a change of query Rod Taylor 22:50
Re: Help with query involving aggregation and joining. Josh Berkus 23:06

Feb. 26, 2003

Thread Author Time
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus 00:42
Postgres locking Bob Smith 00:55
Followup Re: Postgres locking Bob Smith 01:31
performance James Cooper 03:09
OffsetNumber, picksplit, and GiST Itai Zukerman 03:29
Re: Polymorphic? Itai Zukerman 03:40
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 04:43
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello 04:48
Copy from a SELECT val 09:08
WebDB, iAS gyurika 13:19
Re: WebDB, iAS Victor Yegorov 13:21
Re: WebDB, iAS D'Arcy J.M. Cain 13:36
disable constraints rute solipa 14:38
Re: disable constraints Patrik Kudo 14:47
Design Q.:logic in app or db? george young 15:32
Re: OffsetNumber, picksplit, and GiST Itai Zukerman 15:54
Re: disable constraints rute solipa 16:50
Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus 17:08
Re: Design Q.:logic in app or db? Josh Berkus 18:25
btree_gist, gint4_union Itai Zukerman 19:05
Re: Design Q.:logic in app or db? Achilleus Mantzios 19:58
Re: Relation "pg_relcheck" Tilo Schwarz 20:40
Re: Relation "pg_relcheck" Tom Lane 21:09
pgsql problem Grignon Etienne 22:46

Feb. 27, 2003

Thread Author Time
timestamp output as seconds since epoch? A.M. 01:14
Re: timestamp output as seconds since epoch? Rod Taylor 01:30
Re: how can i drop a <unnamed> constraint Christoph Haller 10:13
Re: Copy from a SELECT Christoph Haller 12:44
Re: pgsql problem Christoph Haller 14:41
Re: how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 15:53
using Avg() Mark Connelly@South Central 16:59
Re: Copy from a SELECT Valerie Goodman 18:28
Analyse article Dan Langille 18:51
GiST, Not Using Index Itai Zukerman 19:37
Re: Analyse article Dan Langille 19:59
Re: pgsql problem Grignon Etienne 20:33
Re: GiST, Not Using Index Tom Lane 20:51
use of geometric types in select ? dhoubrechts 21:07
Re: GiST, Not Using Index Itai Zukerman 21:15
Re: pgsql problem Stephan Szabo 22:04
Re: GiST, Not Using Index Tom Lane 22:38
Re: GiST, Not Using Index Itai Zukerman 23:12
Beginner needs help Aaron Chu 23:17

Feb. 28, 2003

Thread Author Time
Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev 00:45
Re: Are scalar type's in/out functions implicitly STRICT? Tom Lane 02:44
Re: Are scalar type's in/out functions implicitly STRICT? Bruno Wolff III 03:24
calling a stored procedure via pqSendQuery victor 03:44
PSQL segmentation fault? Frankie Lam 04:43
Re: pgsql problem Victor Yegorov 06:11
Executing SQL commands via triggers without the use of procedures 📎 Susan Hoddinott 06:31
Re: Copy from a SELECT Christoph Haller 09:34
Re: pgsql problem Christoph Haller 10:08
Query Against a dblink View Takes Too Long to Return Dawn Hollingsworth 12:54
Re: Copy from a SELECT val 13:24
Re: DELETE FROM t WHERE EXISTS Tomasz Myrta 13:28
Optimizing Montrone, Marc -- 7183 15:26
DELETE FROM t WHERE EXISTS Dan Langille 17:16
Re: WebDB, iAS Guy Fraser 17:57
Re: DELETE FROM t WHERE EXISTS Jakub Ouhrabka 19:25
Re: DELETE FROM t WHERE EXISTS Jeff Eckermann 19:30
Re: DELETE FROM t WHERE EXISTS Tom Lane 20:11
Re: DELETE FROM t WHERE EXISTS Stephan Szabo 20:34
Re: DELETE FROM t WHERE EXISTS Robert Treat 20:36
Re: DELETE FROM t WHERE EXISTS Dan Langille 21:56
Re: DELETE FROM t WHERE EXISTS Dan Langille 21:58
Re: DELETE FROM t WHERE EXISTS Dan Langille 22:01
Re: disable constraints Dmitry Tkach 22:42
Re: DELETE FROM t WHERE EXISTS Dmitry Tkach 22:47

March 1, 2003

Thread Author Time
Re: Optimizing Dan Langille 01:12
Re: Optimizing Steve Crawford 01:16
Re: Executing SQL commands via triggers without the use of Stephan Szabo 02:00
Re: Beginner needs help Greg Stark 06:22
Re: use of geometric types in select ? Victor Yegorov 08:37
Re: Beginner needs help Victor Yegorov 08:41
Arrays in Postgresql Processes Aspire Something 12:33
Re: Users and groups Oliver Elphick 13:02
[No subject] bishop 13:50
Epoch extraction Denis Arh 14:47
Epoch extraction Denis Arh 14:53
Re: Executing SQL commands via triggers without the use of procedures Jeff Eckermann 16:35
Re: Denormalizing during select Rod Taylor 17:07
Re: Denormalizing during select Rod Taylor 17:07
Re: Epoch extraction Tom Lane 17:07
Re: Denormalizing during select Tom Lane 17:13
Re: Denormalizing during select Greg Stark 17:53
OUTER JOIN with filter Nicolas Fertig 18:53
Re: Beginner needs help Chad Thompson 22:55
PL/pgSQL Zodiac 22:57

March 2, 2003

Thread Author Time
Re: Beginner needs help Bruno Wolff III 00:23
Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev 00:40
Re: Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev 00:41
Re: OUTER JOIN with filter Stephan Szabo 01:07
Re: OUTER JOIN with filter Bruno Wolff III 01:54
Re: Any limitation in size for return result from SELECT? Stephan Szabo 03:03
Re: Any limitation in size for return result from SELECT? Joe Conway 03:41
Re: Any limitation in size for return result from SELECT? Bruno Wolff III 03:44
HardCORE QUERY HELP!!! Metnetsky 04:20
Re: Dynamic SELECT condition Bruno Wolff III 04:46
Re: Tom Lane 06:10
Re: OUTER JOIN with filter Tom Lane 07:09
Re: OUTER JOIN with filter Stephan Szabo 07:33
default operator class (PostgreSQL's error?) Denis Zaitsev 09:24
Re: Inquiry From Form [pgsql] Greg Stark 14:10
Re: Dynamic SELECT condition Greg Stark 14:19
Re: Dynamic SELECT condition Achilleus Mantzios 16:04
Re: Beginner needs help Tomasz Myrta 18:00
Re: default operator class (PostgreSQL's error?) Tom Lane 18:01
Re: Zodiac 21:58

March 3, 2003

Thread Author Time
Re: default operator class (PostgreSQL's error?) Denis Zaitsev 02:07
Querying Hierarchical Data Eric 02:27
Re: default operator class (PostgreSQL's error?) Tom Lane 03:27
Re: default operator class (PostgreSQL's error?) Denis Zaitsev 05:03
Re: HardCORE QUERY HELP!!! Rajesh Kumar Mallah 06:25
Re: Dynamic SELECT condition Victor Yegorov 07:27
copy help val 09:16
Re: Users and groups Christoph Haller 09:58
Re: copy help Janning Vygen 10:29
complex query Matt Gerginski 10:59
pl/pgsql errors Tomasz Myrta 11:32
Re: pl/pgsql errors Tambet Matiisen 11:45
Re: Dynamic SELECT condition Achilleus Mantzios 12:01
Re: two dates Richard Huxton 12:09
Re: two dates Oliver Elphick 12:32
Re: pl/pgsql errors Tomasz Myrta 12:32

Browse Archives

Prev | Next