pgsql-sql since 2003-10-31 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

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
Re: 7.3 how remove password valid until alban 11:52
curly braces to group outer joins in queries from OpenOffice.org? Palle Girgensohn 12:04
Re: transaction processing after error in statement Jan Wieck 12:27
Re: Getting the row_count value outside of a function Christoph Haller 13:10
Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane 14:39
Re: How to know column constraints via system catalog tables Christoph Haller 15:56
Re: curly braces to group outer joins in queries from Palle Girgensohn 16:15
Re: transaction processing after error in statement Holger Jakobs 16:24
Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane 16:28
Re: curly braces to group outer joins in queries from Palle Girgensohn 16:32
Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane 16:39
Bit strings Yasir Malik 17:33
Re: transaction processing after error in statement 📎 Rajesh Kumar Mallah 19:20
Re: Is there a more elegant way to write this query?... Nick Fankhauser 21:23
Quota query with decent performance? Troels Arvin 22:58
Re: Quota query with decent performance? Josh Berkus 23:41
Re: Quota query with decent performance? Chester Kustarz 23:49

Nov. 12, 2003

Thread Author Time
Re: Quota query with decent performance? Tom Lane 05:17
Re: Quota query with decent performance? Troels Arvin 09:32
Re: Quota query with decent performance? Troels Arvin 10:57
Re: search facilities Martin Kuria 11:28
Re: How to know column constraints via system catalog tables Damon Chong 12:04
SQL substring Guy Korland 13:44
SQL substring Guy Korland 14:07
Re: SQL substring Franco Bruno Borghesi 14:38
Re: SQL substring Bruno Wolff III 15:13
Re: transaction processing after error in statement Jan Wieck 21:17
Looks are important George Weaver 22:12
Re: Is there a more elegant way to write this query?... Terence Kearns 22:53
Re: Looks are important Louise Cofield 23:19
Re: Looks are important Josh Berkus 23:56

Nov. 13, 2003

Thread Author Time
Re: Looks are important George Weaver 03:14
Re: Looks are important Tom Lane 03:31
Re: curly braces to group outer joins in queries from OpenOffice.org? Tõnu Põld 08:57
Re: How to know column constraints via system catalog tables Christoph Haller 10:58
Conversion question Graham Vickrage 11:55
Conversion Problem Graham 12:25
Re: Looks are important George Weaver 13:29
Re: Conversion Problem Richard Huxton 14:40
Re: Conversion Problem Christoph Haller 15:06
Re: Looks are important Louise Cofield 15:22
STRICT function returning a composite type Alexander M. Pravking 16:08
Re: STRICT function returning a composite type Richard Huxton 17:14
Re: STRICT function returning a composite type Alexander M. Pravking 17:19
Re: STRICT function returning a composite type Tom Lane 17:27
Re: STRICT function returning a composite type Alexander M. Pravking 17:32
Re: STRICT function returning a composite type Tom Lane 17:35
Re: STRICT function returning a composite type Alexander M. Pravking 17:42

Nov. 14, 2003

Thread Author Time
Need Help Abdul Wahab Dahalan 01:04
Re: Need Help Bruno Wolff III 05:11
Compare strings which resembles each other Gulshan Babajee 05:30
Substrings by Regular Expression Jim Drummey 17:02

Nov. 15, 2003

Thread Author Time
Programatically switching database ow 04:36
Re: Programatically switching database Peter Eisentraut 10:11
Getting last insert value Yasir Malik 15:18
Re: Programatically switching database ow 16:00
Re: Programatically switching database Peter Eisentraut 16:36
Re: Getting last insert value Guillaume LELARGE 16:40
Re: Getting last insert value Guillaume LELARGE 17:41
Re: Getting last insert value Yasir Malik 17:43
Re: Getting last insert value Greg Stark 17:50
Re: Programatically switching database ow 18:35
Re: Programatically switching database ow 18:37
Re: Programatically switching database Peter Eisentraut 18:42
Re: Programatically switching database ow 19:08
Re: Getting last insert value Yasir Malik 20:11
Re: Getting last insert value Theodore Petrosky 20:54

Nov. 16, 2003

Thread Author Time
Re: Programatically switching database ow 01:50
Re: Programatically switching database Jan Wieck 02:18
Re: Programatically switching database Jan Wieck 02:20
Re: Programatically switching database ow 05:18
schema Kenneth Gonsalves 07:35