pgsql-sql since 2003-10-27 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

Oct. 27, 2003

Thread Author Time
Re: Query Help using Except Bruno Wolff III 03:34
unsubscribe Antony Gubert 08:11
Unsubscribe Mukta Telang 11:03
connectby Sergei Levchenko 14:42
connectby sector119 14:47
Re: Query planner: current_* vs. explicit date Tom Lane 16:05
Re: extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax Christoph Haller 16:39
URGENT!!! changing Column size mohan 17:10
Re: URGENT!!! changing Column size Tomasz Myrta 17:46
Re: URGENT!!! changing Column size CoL 17:48
Re: URGENT!!! changing Column size Gary Stainburn 17:50
Re: URGENT!!! changing Column size Tomasz Myrta 19:01
Error with DROP column mohan 19:35
Re: extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax Josh Berkus 19:35
Re: Error with DROP column Tomasz Myrta 19:48
Re: Error with DROP column Devrim GUNDUZ 19:49
Re: extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax Alexander Vlasenko 19:54

Oct. 28, 2003

Thread Author Time
Re: connectby George Essig 02:23
Re: Error message during compressed backup Senthil Kumar S 08:54
Using % type in Parameters Kumar 09:09
Re: Error message during compressed backup Kumar 09:15
bug in working with TEXT constants ? sad 11:53
Re: URGENT!!! changing Column size Theodore Petrosky 13:00
Re: URGENT!!! changing Column size Franco Bruno Borghesi 13:28
Re: URGENT!!! changing Column size D'Arcy J.M. Cain 13:42
Re: [SQL] connectby Benoît BOURNON 14:29
Re: [SQL] connectby BenLaKnet 14:33
Re: [SQL] connectby Joe Conway 15:04
numeric and float converts to int differently? SZŰCS Gábor 15:08
Re: bug in working with TEXT constants ? Stephan Szabo 15:11
Re: bug in working with TEXT constants ? Tom Lane 15:41
Re: URGENT!!! changing Column size Christoph Haller 15:43
Re: numeric and float converts to int differently? Tom Lane 16:26
Re: numeric and float converts to int differently? SZŰCS Gábor 16:42
Re: URGENT!!! changing Column size SZUCS Gábor 17:02
Re: numeric and float converts to int differently? Greg Stark 18:21
Re: numeric and float converts to int differently? SZUCS Gábor 20:16
Re: numeric and float converts to int differently? Bruno Wolff III 20:31
Re: numeric and float converts to int differently? Christopher Browne 23:11

Oct. 29, 2003

Thread Author Time
SOLVED: Emulating 'connect by prior' using stored proc Merrall, Graeme 01:36
create type input and output function examples Clint Stotesbery 04:06
Table versions 📎 Stef 10:57
Re: [SQL] Table versions Stef 11:21
Re: Table versions Rod Taylor 13:50
Re: [SQL] Table versions Tom Lane 14:30
update from select Gary Stainburn 14:37
Help on update that subselects other records in table, uses joins Jeff Kowalczyk 14:52
Re: update from select Stephan Szabo 14:58
Re: Link Oracle tables in Postgre OpenGis 15:03
Re: update from select Gary Stainburn 15:36
Re: [SQL] Table versions Stef 15:36
Re: Help on update that subselects other records in table, uses joins Josh Berkus 17:42
Re: [SQL] Table versions Greg Stark 17:45
Re: [SQL] Table versions Tom Lane 17:49
Re: Help on update that subselects other records in table, uses joins Bryan Encina 17:53
Re: Help on update that subselects other records in table, uses joins Josh Berkus 18:35
Re: Help on update that subselects other records in table, uses joins Paul Ganainm 19:26

Oct. 30, 2003

Thread Author Time
Using UNION inside a cursor Kumar 08:53
unescaped output of bytea sad 09:31
Re: Using UNION inside a cursor Christoph Haller 10:26
Re: Using UNION inside a cursor Kumar 10:49
strange postgresql failure Tomasz Myrta 11:32
Re: strange postgresql failure Tomasz Myrta 12:27
Bug in Rule+Foreing key constrain? Michele Bendazzoli 12:35
Please help me to slove this SQL statements Freshman 12:38
psqlODBC with SSL 2000info 13:35
Re: Bug in Rule+Foreing key constrain? Stephan Szabo 15:04
Re: Using UNION inside a cursor Tom Lane 15:20
varlena versus null-terminated strings sad 16:12
Re: Bug in Rule+Foreing key constrain? Jan Wieck 17:29
Re: strange postgresql failure Jan Wieck 17:33
Re: Bug in Rule+Foreing key constrain? Michele Bendazzoli 19:01
7.4 and 7.3.5 showstopper (was: Re: Bug in Rule+Foreing key constrain?) 📎 Jan Wieck 19:13
Re: strange postgresql failure Tomasz Myrta 19:14

Oct. 31, 2003

Thread Author Time
Re: Using UNION inside a cursor Kumar 03:46
Re: 7.4 and 7.3.5 showstopper Jan Wieck 04:00
Re: 7.4 and 7.3.5 showstopper (was: Re: Bug in Rule+Foreing Michele Bendazzoli 08:49
conditional query? Frank Morton 13:30
Re: conditional query? Achilleus Mantzios 13:47
Re: conditional query? 📎 mlunnon @ RWA 18:14
selecting problems Shaun Watts 19:19
Re: selecting problems Tomasz Myrta 19:53

Nov. 1, 2003

Thread Author Time
No output while using PEAR DB & formatted time-string Marcus Krause 11:00
Re: No output while using PEAR DB & formatted time-string Marcus Krause 12:05
defaults on updates Martin Marques 13:49
Re: defaults on updates Tom Lane 15:24
Re: [SQL] connectby George Essig 18:38

Nov. 2, 2003

Thread Author Time
Re: conditional query? zen31329 04:04
pgAdmin Ganesan Kanavathy 09:02
Re: pgAdmin Ganesan Kanavathy 11:47
Re: pgAdmin Mailing List 11:53
7.3 how remove password valid until alban 18:03
7.3 : how add user when last user have lost 'createuser' option alban 18:21

Nov. 3, 2003

Thread Author Time
Re: A tricky sql-query... Mark Stosberg 00:42
Re: A tricky sql-query... Rod Taylor 01:35
Re: A tricky sql-query... Christopher Browne 01:40
pg_dump error - Permission denied Kumar 07:14
'invalid' value in timestamp with timezone. Stef 14:58
Re: Help on update that subselects other records in table, uses joins Jeff Kowalczyk 16:45

Nov. 4, 2003

Thread Author Time
Re: create type input and output function examples Christoph Haller 11:18
Re: Using UNION inside a cursor Paul Ganainm 15:02
query assistance Jodi Kanter 15:16
Re: query assistance Richard Huxton 15:43
What's wrong with this group by clause? Franco Bruno Borghesi 21:28
Problems with NEW.* in triggers Jamie Lawrence 22:33
Re: Problems with NEW.* in triggers Tom Lane 22:48
Re: Problems with NEW.* in triggers Josh Berkus 22:52
Re: Problems with NEW.* in triggers Jamie Lawrence 23:14

Nov. 5, 2003

Thread Author Time
Re: Problems with NEW.* in triggers Tom Lane 00:10
Re: Problems with NEW.* in triggers Jamie Lawrence 00:16
Re: query assistance Michael Glaesemann 04:09
UNSUBSCRIBE Atul Pedgaonkar 04:49
How to know column constraints via system catalog tables Damon 09:00
Re: Please help me to slove this SQL statements Patrick JACQUOT (DSI NOISIEL) 09:34
Select and functions Stephen J. Thompson 14:26
Re: Select and functions terry 14:38
SQL Help luisblock 18:30
Re: Select and functions Jeff Eckermann 19:54
avoid circular references Jerome Alet 21:40
Re: Schema boggle... Josh Berkus 21:58

Nov. 6, 2003

Thread Author Time
Re: Schema boggle... Marc G. Fournier 01:45
Re: [HACKERS] Schema boggle... Chris Bowlby 02:31
Re: [HACKERS] Schema boggle... Josh Berkus 05:01
Re: avoid circular references Josh Berkus 05:15
Re: Schema boggle... Greg Stark 05:34
Re: avoid circular references Jerome Alet 06:18
transaction management in plpgsql functions Cris Carampa 09:24
Re: [HACKERS] What's wrong with this group by clause? Franco Bruno Borghesi 17:52
Now() in a function sTesting 22:43
Re: Now() in a function Gaetano Mendola 23:19

Nov. 7, 2003

Thread Author Time
off subject - pg web hosting chester c young 00:39
SQL to PLC to diverter gate, can this be done? Razorbak71 03:31
search facilities Martin Kuria 11:21
Getting the row_count value outside of a function enio 12:53
DateDiff in PostgreSQL George A.J 13:34
Re: DateDiff in PostgreSQL Yasir Malik 13:40
Re: DateDiff in PostgreSQL Yasir Malik 13:45
Re: DateDiff in PostgreSQL Tomasz Myrta 13:47
Re: SQL to PLC to diverter gate, can this be done? Christopher Browne 13:47
Re: DateDiff in PostgreSQL George A.J 13:53
Re: DateDiff in PostgreSQL Rod Taylor 13:55
transaction processing after error in statement holger 22:17

Nov. 8, 2003

Thread Author Time
help me... ron_tabada 06:02
[No subject] ronald 06:52
[No subject] ronald 07:40
query problem ron_tabada 07:44
Re: search facilities Oleg Bartunov 07:49
Re: search facilities George Essig 15:39
Re: 7.3 how remove password valid until Bruce Momjian 21:01
Re: 7.3 : how add user when last user have lost 'createuser' option Bruce Momjian 21:03
Re: 7.3 : how add user when last user have lost 'createuser' option Tom Lane 21:15
Re: off subject - pg web hosting Marc G. Fournier 22:28
Re: off subject - pg web hosting Robert Creager 23:01
Re: plpgsql question Josh Berkus 23:46

Nov. 9, 2003

Thread Author Time
Re: plpgsql question Josh Berkus 00:14
pg 7.4.rc1, Range query performance ow 02:10
Re: pg 7.4.rc1, Range query performance Bruce Momjian 02:17
Re: pg 7.4.rc1, Range query performance Stephan Szabo 02:37
Re: transaction management in plpgsql functions Christopher Browne 20:36
Re: help me... Yasir Malik 20:53
Re: help me... Yasir Malik 20:59
Re: transaction management in plpgsql functions Chester Kustarz 21:14
Re: transaction processing after error in statement Stephan Szabo 22:09

Nov. 10, 2003

Thread Author Time
Re: help me... Christopher Browne 02:59
Dynamic Query for System functions - now() Kumar 07:12
FOR : control structure Guillaume Houssay 11:18
FOR : Structure control pb Guillaume Houssay 11:24
Re: Dynamic Query for System functions - now() Christoph Haller 11:37
Re: Dynamic Query for System functions - now() Kumar 11:57
Re: FOR : Structure control pb Richard Huxton 12:05
Re: Dynamic Query for System functions - now() Achilleus Mantzios 12:18
Re: transaction processing after error in statement Holger Jakobs 12:37
Re: help me... Yasir Malik 13:45
Re: Dynamic Query for System functions - now() George Weaver 13:55
Re: Dynamic Query for System functions - now() Christoph Haller 14:05
Re: Dynamic Query for System functions - now() Stephan Szabo 15:30
Re: transaction processing after error in statement Stephan Szabo 15:43
Re: Louise Cofield 17:17
Re: transaction processing after error in statement Jan Wieck 18:22
Re: transaction processing after error in statement Rod Taylor 18:56
Re: Dynamic Query for System functions - now() Gaetano Mendola 19:12
Re: transaction processing after error in statement Rod Taylor 19:45
Is there a more elegant way to write this query?... Nick Fankhauser - Doxpop 20:57
Is there a more elegant way to write this query?... Nick Fankhauser 21:02
Re: Is there a more elegant way to write this query?... Eric Soroos 21:37

Nov. 11, 2003

Thread Author Time
Re: pg 7.4.rc1, Range query performance ow 00:30
Re: pg 7.4.rc1, Range query performance ow 00:41
Re: pg 7.4.rc1, Range query performance Bruce Momjian 00:50
Re: pg 7.4.rc1, Range query performance Stephan Szabo 00:57
Query Problem Abdul Wahab Dahalan 01:06
Re: pg 7.4.rc1, Range query performance ow 01:10
Re: Query Problem Joe Conway 01:22
Re: pg 7.4.rc1, Range query performance Bruce Momjian 01:54
Re: pg 7.4.rc1, Range query performance Tom Lane 04:13
Re: pg 7.4.rc1, Range query performance Bruce Momjian 05:13
Re: transaction processing after error in statement Holger Jakobs 06:57
Re: How to know column constraints via system catalog tables Christoph Haller 09:58
question to developers sad 11:42
a question to developers sad 11:45
Re: pg 7.4.rc1, Range query performance ow 11:46

Browse Archives

Prev | Next