pgsql-sql since 2004-11-11 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

Nov. 11, 2004

Thread Author Time
Re: A transaction in transaction? Possible? Gaetano Mendola 08:10
Re: A transaction in transaction? Possible? Gaetano Mendola 08:23
Re: Unicode problem inserting records - Invalid UNICODE character David B 19:29
Re: A transaction in transaction? Possible? Stefan Weiss 19:31

Nov. 12, 2004

Thread Author Time
Cascade updates wait until the end of the transaction? Thomas Berg 03:15
Re: Unicode problem inserting records - Invalid UNICODE character 📎 Richard Huxton 08:18
Re: Unicode problem inserting records - Invalid UNICODE Markus Schaber 09:57
TEXT::CIDR/INET::CIDR output confusion Alexander M. Pravking 21:31

Nov. 13, 2004

Thread Author Time
anounce Kenneth Gonsalves 06:48
postgreSQL 8beta beyaNet 14:35
Re: select using regexp does not use indexscan Stephan Szabo 21:39
Re: postgreSQL 8beta Karsten Hilbert 22:48

Nov. 14, 2004

Thread Author Time
Re: select using regexp does not use indexscan Tom Lane 00:02
Re: UPDATE/INSERT on multiple co-dependent tables Karsten Hilbert 08:47
View and subselect related questions Jakub Kaniewski 13:13
Re: postgreSQL 8beta Theodore Petrosky 13:50

Nov. 15, 2004

Thread Author Time
Re: select using regexp does not use indexscan carex 17:12

Nov. 16, 2004

Thread Author Time
Re: Cascade updates wait until the end of the transaction? Stephan Szabo 06:52
Move table between schemas Markus Schaber 09:02
Re: Move table between schemas Andrew Sullivan 11:05
tree structure photo gallery date quiery Gary Stainburn 11:29
Re: Move table between schemas Achilleus Mantzios 12:30
Re: tree structure photo gallery date quiery sad 13:08
Re: tree structure photo gallery date quiery Rod Taylor 13:23
Table definition Bruno Prévost 14:04
Re: Table definition Goutam Paruchuri 15:07
Re: Table definition Peter Eisentraut 15:16
Re: Table definition Sam Mason 15:29
Re: Table definition Bruno Prévost 15:40
Re: Table definition Peter Eisentraut 16:13
Re: Table definition Bruno Prévost 16:49
Re: tree structure photo gallery date quiery Pierre-Frédéric Caillaud 18:51
Counting Distinct Records Thomas F.O'Connell 19:45
Re: Counting Distinct Records Stephan Szabo 20:03
Re: Counting Distinct Records Thomas F.O'Connell 20:09
finding gaps in dates Matt Nuzum 20:56
Re: finding gaps in dates Pierre-Frédéric Caillaud 21:43
Re: Move table between schemas Andrew Sullivan 22:09
Re: Counting Distinct Records Stephan Szabo 22:34
Re: Counting Distinct Records Thomas F.O'Connell 23:02

Nov. 17, 2004

Thread Author Time
Re: tree structure photo gallery date quiery Gary Stainburn 00:35
Re: tree structure photo gallery date quiery Mike Rylander 02:15
Re: tree structure photo gallery date quiery Oleg Bartunov 08:04
Re: tree structure photo gallery date quiery Oleg Bartunov 09:45
Re: tree structure photo gallery date quiery Achilleus Mantzios 10:00
session_id Riccardo G. Facchini 13:13
Re: session_id Richard Huxton 13:49
Re: session_id Riccardo G. Facchini 14:25
Re: session_id Riccardo G. Facchini 14:27
Re: session_id Achilleus Mantzios 14:33
Re: session_id Richard Huxton 14:44
Re: Counting Distinct Records Stephan Szabo 14:52
Re: session_id Riccardo G. Facchini 15:04
Re: session_id Michael Fuhr 15:19
Re: session_id Richard Huxton 15:24
Re: Counting Distinct Records Thomas F.O'Connell 19:27

Nov. 18, 2004

Thread Author Time
Usenet Discussion Proposal Harry Smith 03:01
How to make lo_import and lo_export to use file on client local machine? Premsun Choltanwanich 10:45
Re: session_id Riccardo G. Facchini 12:38
missing... at end of sql expression Justine.Cleary 19:28
Comparing Dates Nick Peters 21:01
Re: Comparing Dates Ian Barwick 21:10
Re: Comparing Dates Thomas F.O'Connell 21:15
Re: Comparing Dates Nick Peters 21:34

Nov. 19, 2004

Thread Author Time
Re: Comparing Dates Greg Stark 05:50
SQL Question Igor Kryltsov 05:57
Re: Comparing Dates Thomas F.O'Connell 06:07
get sequence value of insert command Erik Thiele 08:41
Re: get sequence value of insert command Michael Glaesemann 09:20
Re: get sequence value of insert command Richard Huxton 09:26
Re: get sequence value of insert command Achilleus Mantzios 09:37
Re: get sequence value of insert command Iain 09:49
transactions in functions, possible bug or what I'm doing wrong? Riccardo G. Facchini 11:52
Re: transactions in functions, possible bug or what I'm doing Richard Huxton 12:59
CREATE TEMPORARY TABLE .. ON COMMIT DROP question Riccardo G. Facchini 14:05
Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question Tom Lane 15:08
Re: CREATE TEMPORARY TABLE .. ON COMMIT DROP question Riccardo G. Facchini 15:54
Re: get sequence value of insert command Passynkov, Vadim 15:57
Re: Comparing Dates Guy Fraser 16:05
Re: transactions in functions, possible bug or what I'm doing Michael Fuhr 16:23
Re: transactions in functions, possible bug or what I'm doing Tom Lane 17:08
NULLS and string concatenation Don Drake 17:12
Re: NULLS and string concatenation Bruno Wolff III 17:45
Re: NULLS and string concatenation Richard Huxton 17:48
Re: NULLS and string concatenation Michael Fuhr 17:53
Re: NULLS and string concatenation Don Drake 18:40
Re: NULLS and string concatenation Stephan Szabo 19:04
Re: SQL Question Mischa Sandberg 19:23
Re: NULLS and string concatenation Tom Lane 20:01
Re: NULLS and string concatenation Gregory S. Williamson 20:03
Re: NULLS and string concatenation Terry Lee Tucker 20:14
Re: NULLS and string concatenation Don Drake 20:21

Nov. 20, 2004

Thread Author Time
Re: NULLS and string concatenation terry 00:16
Re: get sequence value of insert command Erik Thiele 09:24
Re: Move table between schemas Markus Schaber 10:44
How to get the max on a char column? Rodrigo Carvalhaes 14:53
Re: How to get the max on a char column? Rodrigo Carvalhaes 15:54
User defined types Reza Shanbehbazari Mirzaei 16:35
Re: Move table between schemas Tom Lane 16:36
Re: How to get the max on a char column? Jeff Eckermann 17:13
Re: JOIN not being calculated correctly Scott Pederick 21:37
Re: JOIN not being calculated correctly Tom Lane 21:51

Nov. 21, 2004

Thread Author Time
Functions return a select in a table, which data type I must use? (Brazilian User) André Toscano 23:07

Nov. 22, 2004

Thread Author Time
Re: missing... at end of sql expression Tom Lane 01:03
Re: missing... at end of sql expression Michael Fuhr 01:09
Re: session_id Bruce Momjian 04:31
Doubt :- Image_Insert sreejith s 13:41
Re: Doubt :- Image_Insert Rod Taylor 13:54
Re: Doubt :- Image_Insert Jerome Alet 14:09
Re: Doubt :- Image_Insert Rod Taylor 14:10
Re: get sequence value of insert command Passynkov, Vadim 14:58
Recursive SETOF function Richard Rowell 15:18
Missing SELECT INTO ... DEFAULT VALUES in plpgsql for composite t ypes Passynkov, Vadim 16:43
Re: Recursive SETOF function Mike Rylander 16:54
Re: Recursive SETOF function Mike Rylander 16:56
Re: Recursive SETOF function Richard Rowell 19:25
Re: [postgres] Re: Recursive SETOF function Mike Rylander 19:39
Re: [postgres] Re: Recursive SETOF function Richard Rowell 20:21
Re: Recursive SETOF function Pierre-Frédéric Caillaud 23:19

Nov. 23, 2004

Thread Author Time
Image Insert Postgresql DB sreejith s 04:21
Re: Image Insert Postgresql DB Vishal Kashyap @ [SaiHertz] 04:37
Re: Image Insert Postgresql DB Kenneth Gonsalves 05:18
Image Insert Doubt sreejith s 06:50
Re: Image Insert Postgresql DB Premsun Choltanwanich 07:18
Re: Image Insert Postgresql DB Kenneth Gonsalves 07:40
Re: Image Insert Postgresql DB Premsun Choltanwanich 08:19
Re: Image Insert Postgresql DB Kenneth Gonsalves 09:29
Re: Image Insert Postgresql DB Premsun Choltanwanich 09:45
PG7.4.5: query not using index on date column Dave Steinberg 14:28
Re: Image Insert Doubt Vishal Kashyap @ [SaiHertz] 18:39
Re: NULLS and string concatenation Andrew Hammond 19:16

Nov. 24, 2004

Thread Author Time
Encrypt data type LO Alberto Pia 16:28
Explicitly rolling back transaction from within a C-Language function Mark Dilger 19:23
Re: Explicitly rolling back transaction from within a C-Language function Michael Fuhr 19:53

Nov. 25, 2004

Thread Author Time
Re: User defined types Tom Lane 18:29
HowTo change encoding type.... 📎 Andrew M 18:43
Re: PG7.4.5: query not using index on date column Tom Lane 18:44
Type Inheritance Andrew Thorley 21:47

Nov. 26, 2004

Thread Author Time
select with a function Jaime Casanova 06:41
Re: HowTo change encoding type.... Peter Eisentraut 07:30
tutorials for complex.sql & complex.c Andrew Thorley 09:56
Re: tutorials for complex.sql & complex.c Richard Huxton 10:26
Querying a list field against another list Aarni Ruuhimäki 14:17
Re: Querying a list field against another list Bruno Wolff III 15:56
Re: Type Inheritance Tom Lane 18:14
Way to stop recursion? Jonathan Knopp 21:03
Re: Way to stop recursion? Tom Lane 21:31
Re: Way to stop recursion? Andrew Sullivan 21:34
Re: Way to stop recursion? Andrew Sullivan 21:36
Re: Way to stop recursion? Jonathan Knopp 21:53
Re: Way to stop recursion? Pierre-Frédéric Caillaud 22:21
Re: Querying a list field against another list m 23:04
Re: Way to stop recursion? Jonathan Knopp 23:56

Nov. 27, 2004

Thread Author Time
how many JOINs ? Konstantin Danilov 11:11
Re: Type Inheritance Andrew Thorley 14:04
Re: Type Inheritance Andrew Thorley 15:33
update/insert data Keith Worthington 17:55

Nov. 28, 2004

Thread Author Time
Re: [despammed] update/insert data Kretschmer Andreas 13:45

Nov. 29, 2004

Thread Author Time
count record in plpgsql Nurdin 02:31
Re: count record in plpgsql Tomasz Myrta 09:30
Re: count record in plpgsql Richard Huxton 09:42
version 7.4 autocommit removed Christoph Haller 09:47
INDEX and LIKE T E Schmitz 12:19
Re: INDEX and LIKE Olivier Hubaut 13:45
Re: PG7.4.5: query not using index on date column Dave Steinberg 16:19
Crystal Report + Bytea field sreejith s 17:01
stored procedures in postgresql user plpgsql RobertD.Stewart 18:37
Re: Way to stop recursion? 📎 Chris Travers 19:13
grouping a many to many relation set Johan Henselmans 20:26
Re: stored procedures in postgresql user plpgsql Michael Fuhr 22:25

Nov. 30, 2004

Thread Author Time
create stored procedure from temporary table Nurdin 02:57
Re: create stored procedure from temporary table Christopher Browne 04:09
Re: TEXT::CIDR/INET::CIDR output confusion Bruce Momjian 04:49
Re: stored procedures in postgresql user plpgsql Michael Fuhr 04:56
Re: TEXT::CIDR/INET::CIDR output confusion Tom Lane 05:07
session-wide autocommit off Christoph Haller 08:40
Re: [despammed] session-wide autocommit off Andreas Kretschmer 09:03
Re: grouping a many to many relation set Richard Huxton 09:25
Re: session-wide autocommit off Richard Huxton 09:26
Re: session-wide autocommit off Christoph Haller 12:08
inserting values into types Andrew Thorley 23:51

Dec. 1, 2004

Thread Author Time
Re: inserting values into types Michael Fuhr 00:17
Re: grouping a many to many relation set Johan Henselmans 05:57
order by problem Simon Moses 06:14
SET AUTOCOMMIT TO OFF Christoph Haller 14:20
Re: SET AUTOCOMMIT TO OFF Tom Lane 15:42
find the "missing" rows Kevin B. 15:43
Re: inserting values into types Michael Fuhr 17:53
Found Large Files.. what objects are they? Yudie 18:07
Query is slower Sandro Joel Eller 19:26
Re: Found Large Files.. what objects are they? Michael Fuhr 20:09
Re: Found Large Files.. what objects are they? Tom Lane 20:10
Re: Query is slower Michael Fuhr 20:31
Re: inserting values into types Andrew Thorley 21:58
Re: inserting values into types Tom Lane 22:11
Re: Query is slower Stephan Szabo 22:23
Re: inserting values into types Karsten Hilbert 22:43
Re: Found Large Files.. what objects are they? Christopher Browne 22:46

Dec. 2, 2004

Thread Author Time
Re: find the "missing" rows Tom Lane 01:53
invalid 'having' clause Iain 02:22

Browse Archives

Prev | Next