pgsql-sql since 2003-02-24 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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
Re: HardCORE QUERY HELP!!!	Tomasz Myrta	12:41
Re: Executing SQL commands via triggers without the use of procedures	Oleg Samoylov	13:22
Re: Dynamic SELECT condition	Oleg Samoylov	13:30
Re: Querying Hierarchical Data	Lex Berezhny	15:31
Re: Querying Hierarchical Data	Rajesh Kumar Mallah	15:40
Re: Querying Hierarchical Data	Victor Yegorov	16:34
Checking my HD space (noarchive)	Ries van Twisk	16:36
Insert multiple Rows	Saint X	16:38
Query Against a dblink View Takes Too Long to Return	Dawn Hollingsworth	16:58
Re: complex query	Victor Yegorov	17:18
Re: Insert multiple Rows	Victor Yegorov	17:32
Suggestion: set session authorization with password	Aasmund Midttun Godal	17:49
Re: Insert multiple Rows	Oliver Elphick	17:52
Re: Beginner needs help	Josh Berkus	18:18
Re: HardCORE QUERY HELP!!!	Erwin Moller	18:24
Re: Querying Hierarchical Data	Joe Conway	18:25
Re: OUTER JOIN with filter	Josh Berkus	18:30
Re: Querying Hierarchical Data	Robert Treat	18:34
Re: Querying Hierarchical Data	Josh Berkus	18:34
LIMIT and SUBQUERIES	Chris	18:54
Re: OUTER JOIN with filter	Tom Lane	19:17

Browse Archives

Prev | Next