pgsql-sql since 2004-11-19 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. 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
Re: grouping a many to many relation set Michael Fuhr 02:45
Re: invalid 'having' clause Tom Lane 02:54
Re: SET AUTOCOMMIT TO OFF sad 05:11
Re: order by problem Tomasz Myrta 07:18
Re: invalid 'having' clause Iain 07:46
Re: SET AUTOCOMMIT TO OFF Richard Huxton 08:56
Re: order by problem Richard Huxton 09:03
Re: find the "missing" rows Andrew - Supernews 10:07

Dec. 3, 2004

Thread Author Time
Failed system call was shmget(key=1, size=1155072, 03600). Andrew M 09:00
Re: Failed system call was shmget(key=1, size=1155072, 03600). Achilleus Mantzios 14:09
Re: Failed system call was shmget(key=1, size=1155072, 03600). Andrew Sullivan 17:19
Re: grouping a many to many relation set Johan Henselmans 20:02
sum query Keith Worthington 21:33

Dec. 4, 2004

Thread Author Time
Re: [despammed] sum query Andreas Kretschmer 09:41
Re: sum query Andrew - Supernews 12:38
Re: sum query Kretschmer Andreas 15:14

Dec. 5, 2004

Thread Author Time
Re: inserting values into types Yasir Malik 04:13
Making dirty reads possible? Ellert van Koperen 17:48

Dec. 6, 2004

Thread Author Time
Re: inserting values into types Michael Fuhr 04:03
Postgesql 8 beta 5: ecpg and date type - Access violations Paulo Assis 04:18
Making dirty reads possible? pgsql-sql 17:35
Set Returning Function problem Alvaro Nunes Melo 18:06
Re: Set Returning Function problem Tom Lane 18:47
MO: SQL Query Performance tips Michael Ossareh 21:06
Re: Making dirty reads possible? Greg Stark 21:28
Re: Making dirty reads possible? Josh Berkus 21:51

Dec. 7, 2004

Thread Author Time
Insert successful but data not found Mian Yong Leow 02:58
Re: Making dirty reads possible? Pierre-Frédéric Caillaud 08:27

Dec. 8, 2004

Thread Author Time
Unresolved external: tgetent Christoph Haller 12:50
Indexing Strategy Matthew Engelbert 19:21

Dec. 9, 2004

Thread Author Time
filtering Kevin B. 15:25
parse error at or near "(" -- Huh??? Alex Beamish 20:19

Dec. 10, 2004

Thread Author Time
Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 11:40
Cast NULL into Timestamp? Wei Weng 19:24
Create Calendar Muhyiddin A.M Hayat 19:26
Re: Indexing Strategy Josh Berkus 23:42

Dec. 11, 2004

Thread Author Time
Re: Cast NULL into Timestamp? Steve Crawford 00:10
Re: Cast NULL into Timestamp? Stephan Szabo 00:48
Re: Indexing Strategy Matthew Engelbert 00:57
Re: Query is not using index when it should Stephan Szabo 02:28
Re: Create Calendar Michael Fuhr 04:11
replacing mysql enum Kenneth Gonsalves 05:00
Re: Cast NULL into Timestamp? Josh Berkus 05:11
Re: Create Calendar Joe Conway 11:55
Re: replacing mysql enum Ian Barwick 12:25
PREPARED STATEMENT NosyMan 12:47
Re: Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 14:17
Re: [GENERAL] Query is not using index when it should Steinar H. Gunderson 14:32
Re: replacing mysql enum Stephan Szabo 15:47
Re: [GENERAL] Query is not using index when it should Michael Fuhr 16:25
Re: replacing mysql enum Rod Taylor 16:35
Re: replacing mysql enum Stephan Szabo 16:45
Re: replacing mysql enum Ian Barwick 17:06
Re: Cast NULL into Timestamp? Frank Bax 17:10
Re: replacing mysql enum Greg Stark 17:25
Re: replacing mysql enum Tom Lane 17:56
Re: replacing mysql enum Josh Berkus 18:16
Re: filtering Bruno Wolff III 19:01

Dec. 12, 2004

Thread Author Time
Re: [GENERAL] Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 08:32

Dec. 13, 2004

Thread Author Time
Re: Insert successful but data not found Michael Fuhr 02:12
Re: parse error at or near "(" -- Huh??? Michael Fuhr 02:18
Re: parse error at or near "(" -- Huh??? Tom Lane 02:45
Re: Query is not using index when it should Josh Berkus 02:48
Re: Unresolved external: tgetent Bruce Momjian 03:13

Browse Archives

Prev | Next