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

Sept. 12, 2004

Thread Author Time
Re: create unique index schema.index_name on table (column)? Michael Glaesemann 05:48
Re: create unique index schema.index_name on table (column)? Michael Glaesemann 05:54
Re: create unique index schema.index_name on table (column)? Tom Lane 05:55
Re: create unique index schema.index_name on table (column)? mØntar3 20:33

Sept. 13, 2004

Thread Author Time
what is maximum size of "text" datatype in postgres? Smit 08:35
Re: what is maximum size of "text" datatype in postgres? Christopher Browne 09:31
Interpolation and extrapolation in SQL David Garamond 15:03
Re: Interpolation and extrapolation in SQL Tom Lane 15:16
Re: CREATE RULE ignored, what did I do wrong andrew 18:13
Difficulties to use a Set Returning Function on a join Alvaro Nunes Melo 22:03

Sept. 15, 2004

Thread Author Time
explain analyze results are different for each iteration Robert Davis 01:21
Re: explain analyze results are different for each iteration Gregory S. Williamson 01:33
Re: explain analyze results are different for each iteration Stephan Szabo 02:07
implementing an out-of-transaction trigger Iain 03:03
Re: sleep function Sanjay Singh 09:22
Preserving column order when recreating table. Stef 12:24
Re: Preserving column order when recreating table. Andrew Sullivan 13:19
Re: Preserving column order when recreating table. Stef 14:22
Re: Preserving column order when recreating table. Andrew Sullivan 14:42
Re: Preserving column order when recreating table. Stef 15:07
Re: Preserving column order when recreating table. Andrew Sullivan 15:36
Re: implementing an out-of-transaction trigger Mike Rylander 16:03

Sept. 16, 2004

Thread Author Time
Re: implementing an out-of-transaction trigger Iain 02:02
Re: implementing an out-of-transaction trigger Greg Stark 03:57
Re: implementing an out-of-transaction trigger Iain 05:15
PL/pgSQL multidimension (matrix) array in function Sergio Fantinel 17:10
CREATE TABLE AS SELECT.... Arash Zaryoun 20:57

Sept. 17, 2004

Thread Author Time
How to check postgres running or not ? 📎 Sandeep Gaikwad 05:18
Implicit Transactions Chip Gobs 14:44
1-byte integers stig erikson 21:40

Sept. 18, 2004

Thread Author Time
Sequence of SQL command execution involving triggers and stored procedures. Omkar Rath 04:54
Re: 1-byte integers Greg Stark 15:39
Re: Sequence of SQL command execution involving triggers and stored procedures. Tom Lane 16:39
Re: How to check postgres running or not ? Christopher Browne 17:20
Re: How to check postgres running or not ? Gaetano Mendola 18:36

Sept. 19, 2004

Thread Author Time
Re: How to check postgres running or not ? Worik 01:57
Re: How to check postgres running or not ? Geoffrey 12:01
ORDER BY and NULLs T E Schmitz 14:57
Re: ORDER BY and NULLs terry 15:17
Re: How to check postgres running or not ? Jeff Eckermann 16:08
Re: ORDER BY and NULLs Jean-Luc Lachance 16:19
Re: How to check postgres running or not ? Tom Lane 16:25
Re: ORDER BY and NULLs T E Schmitz 16:36
Re: How to check postgres running or not ? Andrew Sullivan 16:57
Re: ORDER BY and NULLs Tom Lane 16:58
Re: How to check postgres running or not ? Tom Lane 17:12
Re: ORDER BY and NULLs T E Schmitz 17:18
Re: ORDER BY and NULLs Greg Stark 18:37
Re: ORDER BY and NULLs Tom Lane 19:00
Re: ORDER BY and NULLs T E Schmitz 20:22
Re: ORDER BY and NULLs Tom Lane 20:30
Re: ORDER BY and NULLs T E Schmitz 20:50
Re: How to check postgres running or not ? Gaetano Mendola 20:57
Re: How to check postgres running or not ? Gaetano Mendola 21:01

Sept. 20, 2004

Thread Author Time
Re: How to check postgres running or not ? Andrew Sullivan 00:20
Re: How to check postgres running or not ? Worik 00:34
Re: ORDER BY and NULLs Greg Stark 00:51
Re: How to check postgres running or not ? Worik 01:04
Re: How to check postgres running or not ? Tom Lane 01:11
Re: How to check postgres running or not ? Christopher Browne 01:33
Re: How to check postgres running or not ? Arne Stoelck 02:33
Test for file exists? Richard Sydney-Smith 03:16
Re: How to check postgres running or not ? Reiner Dassing 07:20
Re: ORDER BY and NULLs T E Schmitz 08:04
Re: How to check postgres running or not ? Gaetano Mendola 10:05
Re: How to check postgres running or not ? Peter Eisentraut 11:47
Re: How to check postgres running or not ? Bruce Momjian 12:19
Re: Implicit Transactions Bruce Momjian 12:34
Re: How to check postgres running or not ? Theodore Petrosky 13:46
COUNT(*) to find records which have a certain number of dependencies ? T E Schmitz 15:14
Re: COUNT(*) to find records which have a certain number of T E Schmitz 16:19
Re: Test for file exists? Josh Berkus 16:30
Re: COUNT(*) to find records which have a certain number of Rod Taylor 16:31
Re: COUNT(*) to find records which have a certain number of Martin Knipper 16:44
Re: COUNT(*) to find records which have a certain number of T E Schmitz 17:59
Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 18:32
Re: COUNT(*) to find records which have a certain number of Greg Stark 18:33
JOIN performance Dean Gibson (DB Administrator) 19:24
Re: COUNT(*) to find records which have a certain number of T E Schmitz 19:50
Help with function CHRIS HOOVER 20:36
Re: COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 20:45
Re: Help with function Stephan Szabo 20:51
Re: COUNT(*) to find records which have a certain number of Chester Kustarz 20:55
unsubscribe Ramiro Batista da Luz 21:30
Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 21:39
Re: CREATE TABLE AS SELECT.... Andrew Hammond 21:56
Re: JOIN performance Tom Lane 23:06
Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ? Tom Lane 23:23

Sept. 21, 2004

Thread Author Time
Re: JOIN performance Dean Gibson (DB Administrator) 00:10
Re: JOIN performance Tom Lane 00:54
Problem with functions Michael Snodgrass 01:36
Re: JOIN performance Dean Gibson (DB Administrator) 01:41
Re: JOIN performance Chester Kustarz 04:09
Re: JOIN performance Tom Lane 04:10
Re: JOIN performance Dean Gibson (DB Administrator) 04:41
Re: PL/pgSQL multidimension (matrix) array in function Joe Conway 04:44
Re: JOIN performance Tom Lane 05:19
[ocpfree] Info Needed about OCA birdy edwards 05:55
Re: JOIN performance Dean Gibson (DB Administrator) 06:24
Difference in DATEs Dean Gibson (DB Administrator) 07:38
postgres rpm Nagaraj GS 07:46
degradation in performance Alain Reymond 11:27
Re: degradation in performance Martin Knipper 11:32
Re: degradation in performance Stephan Szabo 12:25
Re: degradation in performance Pierre-Frédéric Caillaud 12:41
Re: Difference in DATEs Tom Lane 14:01
Re: Help with function CHRIS HOOVER 14:23
Re: Help with function Stephan Szabo 15:25
Porting problem from Informix to Postgres... Marco Gaiarin 15:42
Re: Difference in DATEs Dean Gibson (DB Administrator) 15:53
Re: Different topic Dean Gibson (DB Administrator) 16:19
raise is not working CHRIS HOOVER 16:44
Re: [SQL] COUNT(*) to find records which have a certain number of dependencies ? Greg Stark 17:14
Re: raise is not working Josh Berkus 17:53
Re: JOIN performance Greg Stark 18:26
Re: COUNT(*) to find records which have a certain number of dependencies Mischa Sandberg 22:16
Re: raise is not working Tom Lane 22:29

Sept. 22, 2004

Thread Author Time
where clause on a left outer join Cris Carampa 09:08
Doubt S.Sreejith 11:11
Re: Porting problem from Informix to Postgres... Achilleus Mantzios 11:48
Porting problem from Informix to Postgres... Marco Gaiarin 12:17
Re: Porting problem from Informix to Postgres... Michalis Kabrianis 12:34
Re: Porting problem from Informix to Postgres... Josh Berkus 17:16
LIKE operator and string comparison Wei Weng 22:54
Re: LIKE operator and string comparison Tom Lane 23:09
Re: LIKE operator and string comparison Wei Weng 23:19
Re: LIKE operator and string comparison Tom Lane 23:20

Sept. 23, 2004

Thread Author Time
plpgsql syntax Kemin Zhou 15:32
Re: plpgsql syntax Yasir Malik 16:02
Re: plpgsql syntax Tom Lane 16:19
Re: raise is not working CHRIS HOOVER 16:31
Re: raise is not working Tom Lane 16:52
Re: raise is not working CHRIS HOOVER 17:04
Re: raise is not working Tom Lane 17:11
need "row number" Karsten Hilbert 20:24

Sept. 24, 2004

Thread Author Time
Re: need ``row number`` Ian Harding 00:43
Re: need ``row number`` Karsten Hilbert 07:21
select column by position Jennifer Lee 11:50
Re: need ``row number`` Tom Lane 14:20
INDEX problem Vladimir S. Tikhonjuk 14:21
How to insert values in bytea? Oliver Nolden 15:39
Re: [SQL] need ``row number`` Greg Stark 20:34
Re: select column by position Chester Kustarz 21:00
Re: [SQL] need ``row number`` Ian Harding 21:49

Sept. 26, 2004

Thread Author Time
plpgsql - accessing fields of record type Szálka Tamás 16:15
Re: plpgsql - accessing fields of record type Michael Fuhr 18:33

Sept. 27, 2004

Thread Author Time
Re: where clause on a left outer join Stephan Szabo 00:21
Re: Problem with functions Stephan Szabo 00:34
Re: postgres rpm Devrim GUNDUZ 06:31
Re: COUNT(*) to find records which have a certain number of T E Schmitz 09:45
Temp Tables sad 13:12
Re: COUNT(*) to find records which have a certain number of dependencies Greg Stark 13:27
Error : could not send data to client vab ip 16:34

Sept. 28, 2004

Thread Author Time
date_trunc'd timestamp index possible? D. Duccini 00:14
Postgres Doubt sreejith s 03:27
FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios 06:14
Re: Best way to know if there is a row Achilleus Mantzios 12:24
Best way to know if there is a row Martin Marques 12:55
Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios 13:34
CHECK col A not NULL if col B='x' T E Schmitz 14:02
Re: FOREIGN KEY and AccessExclusiveLock Tom Lane 14:05
Re: CHECK col A not NULL if col B='x' Martin Marques 14:12
Re: CHECK col A not NULL if col B='x' Alexander M. Pravking 14:15
Re: Best way to know if there is a row Tom Lane 14:24
Re: CHECK col A not NULL if col B='x' T E Schmitz 14:38
Re: CHECK col A not NULL if col B='x' T E Schmitz 15:01
Re: Doubt Paul Thomas 20:39
Re: CHECK col A not NULL if col B='x' Tom Lane 22:36

Sept. 29, 2004

Thread Author Time
Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios 05:36
Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios 13:19
Re: Porting problem from Informix to Postgres... Marco Gaiarin 13:21
SELECT with Function Paulo Nievierowski 13:51
multiple insert van Elsacker Frans 17:12

Sept. 30, 2004

Thread Author Time
Re: FOREIGN KEY and AccessExclusiveLock Achilleus Mantzios 10:51

Oct. 1, 2004

Thread Author Time
psql variable interpolation from command line Jeff Boes 13:24
Re: psql variable interpolation from command line Jeff Boes 13:28
Re: SELECT with Function Marcin Piotr Grondecki 16:46
Re: date_trunc'd timestamp index possible? Bruno Wolff III 18:28
Re: date_trunc'd timestamp index possible? D. Duccini 18:28
Re: date_trunc'd timestamp index possible? Bruno Wolff III 18:44