pgsql-sql since 2005-01-22 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

Jan. 22, 2005

Thread Author Time
testing/predicting optimization using indexes TJ O'Donnell 00:51
update from multiple rows adam etienne 12:51
Question about a select Kretschmer Andreas 15:56
Re: update from multiple rows Michael Fuhr 19:35
editors with colum positioning for debugging? Joel Fradkin 22:12
Re: editors with colum positioning for debugging? Tom Lane 22:21
Re: editors with colum positioning for debugging? Joel Fradkin 22:36

Jan. 23, 2005

Thread Author Time
Re: editors with colum positioning for debugging? John DeSoi 01:58
Re: update from multiple rows adam etienne 11:36
Re: Question about a select Harald Fuchs 15:37
How to update dependent tables AND design considerations Klaus W. 17:23
Re: returning a record from PL/pgSQL Michael Fuhr 19:00
Invalid Input syntax for type bigint Ryan Miranda 22:59

Jan. 24, 2005

Thread Author Time
Moving from Transact SQL to PL/pgsql Duffy House 03:22
Re: OID's Mihail Nasedkin 03:57
Re: Invalid Input syntax for type bigint Michael Fuhr 04:10
Re: OID's Michael Fuhr 04:58
Re: OID's Mihail Nasedkin 05:21
Re: update from multiple rows Michael Fuhr 06:45
Looking up table names by REFERENCES Steve Castellotti 15:09
How to find out programmatically whether a query on a view will use an index? Martin Schäfer 16:34
Re: How to find out programmatically whether a query on a view will use an index? Tom Lane 17:12
Moving from Transact SQL to PL/pgSQL Kevin Duffy 17:14
Re: How to find out programmatically whether a query on a view will use an index? Martin Schäfer 17:22
Re: update from multiple rows franco 17:44
Value specific sequences? Dmitri Bichko 19:10
Re: update from multiple rows mrblonde 23:32

Jan. 25, 2005

Thread Author Time
datediff is there something like it? Joel Fradkin 15:11
Re: datediff is there something like it? Achilleus Mantzios 16:33
difficult JOIN Thomas Chille 17:06
Re: "How do I ..." SQL question zeus 17:32
Re: How to find out programmatically whether a query on a view will use an index? Bruno Wolff III 17:40
Re: datediff is there something like it? Joel Fradkin 17:54
Re: converting Oracle scripts to PostgreSQL Dennis Sacks 18:27
Re: [SQL] OFFSET impact on Performance??? Greg Stark 18:28
Re: converting Oracle scripts to PostgreSQL Clint Stotesbery 18:39
Re: datediff is there something like it? Oleg Bartunov 19:03
Re: Looking up table names by REFERENCES Michael Fuhr 19:10
Re: Moving from Transact SQL to PL/pgSQL Michael Fuhr 19:19
Re: Moving from Transact SQL to PL/pgSQL Dennis Sacks 20:19
Re: How to update dependent tables AND design considerations Thomas F.O'Connell 20:35
Re: Moving from Transact SQL to PL/pgsql John DeSoi 21:06

Jan. 26, 2005

Thread Author Time
Re: update from multiple rows Franco Bruno Borghesi 00:12
same question little different test MSSQL vrs Postgres Joel Fradkin 03:50
Sorry I see my first question did not get posted (maybe because of the attatchments) Joel Fradkin 03:54
Re: same question little different test MSSQL vrs Postgres Dennis Sacks 04:21
Re: same question little different test MSSQL vrs Postgres Greg Stark 06:26
working with multidimensional arrays in plpgsql Sibtay Abbas 07:02
private table Din Adrian 08:13
Re: [despammed] private table Andreas Kretschmer 08:33
Re: Sorry I see my first question did not get posted (maybe Richard Huxton 08:50
Re: private table Richard Huxton 08:55
Re: How to find out programmatically whether a query on a view will use an index? Martin Schäfer 09:10
Re: working with multidimensional arrays in plpgsql Richard Huxton 09:29
Re: [SQL] OFFSET impact on Performance??? Andrei Bintintan 10:11
Re: [SQL] OFFSET impact on Performance??? Leeuw van der, Tim 10:36
Re: working with multidimensional arrays in plpgsql Sibtay Abbas 11:06
Re: SQL Query Performance tips Michael Ossareh 13:02
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 13:28
Re: [SQL] OFFSET impact on Performance??? Alex Turner 13:47
Re: [SQL] OFFSET impact on Performance??? Richard Huxton 13:57
Re: same question little different test MSSQL vrs Postgres Richard Huxton 13:58
[No subject] Matteo Braidotti 14:28
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 14:58
Re: Moving from Transact SQL to PL/pgsql George Essig 15:01
Re: same question little different test MSSQL vrs Postgres Richard Huxton 15:20
Re: ***SPAM*** Re: same question little different test MSSQL Franco Bruno Borghesi 15:55
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 16:02
Re: same question little different test MSSQL vrs Postgres Greg Stark 16:20
Re: same question little different test MSSQL vrs Postgres Richard Huxton 16:27
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 16:31
Re: same question little different test MSSQL vrs Postgres Greg Stark 16:50
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 17:04
Re: ***SPAM*** Re: same question little different test MSSQL Franco Bruno Borghesi 17:12
Re: same question little different test MSSQL vrs Postgres Richard Huxton 17:39
Postgresql number of command Wilton 17:43
Re: working with multidimensional arrays in plpgsql Josh Berkus 18:05
Re: datediff is there something like it? Bruno Wolff III 20:13
Re: same question little different test MSSQL vrs Postgres Dennis Sacks 20:57
Re: same question little different test MSSQL vrs Postgres Bruno Wolff III 21:04
Re: testing/predicting optimization using indexes PFC 21:45
Re: same question little different test MSSQL vrs Postgres Andrew Hammond 22:15
Re: testing/predicting optimization using indexes TJ O'Donnell 22:29
Re: testing/predicting optimization using indexes PFC 23:07

Jan. 27, 2005

Thread Author Time
Rule problem with OLD / NEW record set Ralph Graulich 01:42
Re: Moving from Transact SQL to PL/pgSQL Clint Stotesbery 02:12
Re: OFFSET impact on Performance??? David Brown 03:50
Re: Complete instruction in a trigger Richard Huxton 11:35
Constraint on 2 column possible? Andrei Bintintan 11:44
Re: Constraint on 2 column possible? Mike Rylander 12:02
Re: Constraint on 2 column possible? Sean Davis 12:08
Complete instruction in a trigger Wilton 12:21
What's the equivalent in PL/pgSQL KÖPFERL Robert 12:46
Foreign Key relationship between two databases 📎 Sandeep Gaikwad 13:17
Re: [SQL] Foreign Key relationship between two databases Stephan Szabo 13:35
Re: What's the equivalent in PL/pgSQL Sean Davis 13:57
Re: Complete instruction in a trigger 📎 Wilton 14:02
Re: Foreign Key relationship between two databases Dawid Kuroczko 14:04
Re: same question little different test MSSQL vrs Postgres Joel Fradkin 14:11
URL activation through trigger 📎 Sandeep Gaikwad 14:38
Hardware for best performance was same question little different test MSSQL vrs Postgres Joel Fradkin 14:40
Re: Complete instruction in a trigger Tom Lane 15:06
Re: [SQL] URL activation through trigger Sean Davis 15:07
Need SELECT rights to UPDATE/DELETE WHERE? cpp 15:46
Re: What's the equivalent in PL/pgSQL KÖPFERL Robert 16:10
hardware mod based on feedback from the list Joel Fradkin 16:51
Re: hardware mod based on feedback from the list Richard Huxton 17:11
Re: Function Doubt Richard Huxton 17:13
Function Doubt Wilton 17:32
Re: hardware mod based on feedback from the list Keith Worthington 17:35
Re: What's the equivalent in PL/pgSQL Sean Davis 18:02

Jan. 28, 2005

Thread Author Time
Re: contrib/intarray doc/tutorial needed Achilleus Mantzios 08:31
[No subject] Deepthi Darshan 08:39
Re: Richard Huxton 09:11
calling JAVA UDF through trigger 📎 Swati Gadre 13:49
Calendar Function Muhyiddin A.M Hayat 14:26
error: cast the timestam expression friendVU admin 14:55
Re: error: cast the timestam expression Tom Lane 15:04
Re: error: cast the timestam expression Michael Glaesemann 15:04
Re: Calendar Function Franco Bruno Borghesi 15:46
plpgsql select into with multiple target variables John DeSoi 21:02
Re: plpgsql select into with multiple target variables PFC 21:11

Jan. 29, 2005

Thread Author Time
Re: same question little different test MSSQL vrs Postgres Mischa 05:58

Jan. 30, 2005

Thread Author Time
plpgsql functions and NULLs Don Drake 19:41

Jan. 31, 2005

Thread Author Time
error in function!! Ing. Jhon Carrillo 18:59
Re: plpgsql functions and NULLs Thomas F.O'Connell 20:25
Re: plpgsql functions and NULLs Don Drake 21:06
Re: plpgsql functions and NULLs Thomas F.O'Connell 21:14
Re: plpgsql functions and NULLs Stephan Szabo 21:31
number os commands inside transaction block Luiz Rafael Culik Guimaraes 21:54
Re: number os commands inside transaction block Michael Fuhr 22:13
Re: plpgsql functions and NULLs Don Drake 22:27
Re: number os commands inside transaction block Luiz Rafael Culik Guimaraes 22:29
Re: number os commands inside transaction block Scott Marlowe 22:49
Re: number os commands inside transaction block Michael Fuhr 22:54

Feb. 1, 2005

Thread Author Time
Re: plpgsql functions and NULLs Stephan Szabo 00:32
Re: plpgsql functions and NULLs Don Drake 02:12
BLOBs vs BYTEA Sam Adams 02:26
Re: plpgsql functions and NULLs Tom Lane 03:37
Re: BLOBs vs BYTEA Dennis Sacks 03:51
Re: error in function!! John DeSoi 04:42
Re: Iain 04:54
Re: Need SELECT rights to UPDATE/DELETE WHERE? Tom Lane 05:34
problem while converting sybase quries to postgres imam 07:14
Re: BLOBs vs BYTEA Achilleus Mantzios 08:04
Re: [SQL] OFFSET impact on Performance??? PFC 09:16
case sensitive/insensitive confusion Christoph Haller 09:50
Re: case sensitive/insensitive confusion Peter Eisentraut 10:14
Re: [SQL] OFFSET impact on Performance??? Sean Davis 11:38
Re: case sensitive/insensitive confusion Christoph Haller 11:44
Re: case sensitive/insensitive confusion Theodore Petrosky 12:48
Re: BLOBs vs BYTEA Karl Denninger 15:01
MSSQL versus Postgres timing Joel Fradkin 16:54
Re: MSSQL versus Postgres timing Scott Marlowe 16:59
Re: Dennis Sacks 17:00
Re: MSSQL versus Postgres timing Michael Fuhr 17:06
Re: MSSQL versus Postgres timing Bricklen Anderson 17:25
Re: case sensitive/insensitive confusion Tom Lane 18:36
Re: MSSQL versus Postgres timing Joel Fradkin 19:23
Re: MSSQL versus Postgres timing 📎 Joel Fradkin 19:26
Re: MSSQL versus Postgres timing Joel Fradkin 20:19
Re: MSSQL versus Postgres timing 📎 Joel Fradkin 20:19
Re: MSSQL versus Postgres timing PFC 21:47
Re: MSSQL versus Postgres timing Tom Lane 21:53
Re: MSSQL versus Postgres timing Joel Fradkin 22:09

Feb. 2, 2005

Thread Author Time
Re: Calendar Function Muhyiddin A.M Hayat 02:53
Re: Calendar Function Bradley Miller 03:03
Re: Calendar Function Michael Fuhr 03:45
plpgsql functions to 'C' functions Peter Manchev 13:57
pgdump by schema? Bradley Miller 15:33
Re: pgdump by schema? Adam Witney 15:46
Re: pgdump by schema? Kretschmer Andreas 15:46
Re: pgdump by schema? Michael Fuhr 15:54
Re: pgdump by schema? Bradley Miller 15:58
locale with os x Theodore Petrosky 16:02
pg_restore problem Bradley Miller 20:17
Re: pg_restore problem Joel Fradkin 20:46
PL/PgSQL - returning multiple columns ... Marc G. Fournier 21:10
Re: pg_restore problem Tom Lane 21:24
Re: PL/PgSQL - returning multiple columns ... George Weaver 22:45

Feb. 3, 2005

Thread Author Time
problem with postgres Luiz Rafael Culik Guimaraes 01:33
problem with postgres Luiz Rafael Culik Guimaraes 01:43
Re: plpgsql functions to 'C' functions Michael Fuhr 06:21
Re: problem with postgres Michael Fuhr 06:49
Re: problem while converting sybase quries to postgres Richard Huxton 09:33
Tunning postgresql on linux (fedora core 3) Din Adrian 09:55
Re: problem while converting sybase quries to postgres Richard Huxton 10:52
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 10:54
pg primary key bug? pginfo 12:53
Re: plpgsql functions to 'C' functions Peter Manchev 13:31
Re: pg primary key bug? pginfo 13:52
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 13:56
Re: pg primary key bug? Michael Glaesemann 14:14
Re: pg_restore problem Bradley Miller 14:16
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 14:52
Re: [PERFORM] Tunning postgresql on linux (fedora core 3) Richard Huxton 15:15
Re: pg_restore problem Richard Huxton 15:25
problem with backup and restore (probaly stupit newb thing) Joel Fradkin 16:14
Re: pg primary key bug? Richard_D_Levine 16:30
Re: PL/PgSQL - returning multiple columns ... Marc G. Fournier 16:48

Browse Archives

Prev | Next