pgsql-sql since 2004-09-20 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. 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
Re: [SQL] date_trunc'd timestamp index possible? Tom Lane 18:49
Re: date_trunc'd timestamp index possible? Tom Lane 21:17
Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 22:53

Oct. 2, 2004

Thread Author Time
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Bruno Wolff III 00:50
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Gaetano Mendola 08:43
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Peter Eisentraut 17:41
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 18:22
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Bruno Wolff III 20:04

Oct. 3, 2004

Thread Author Time
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Bruno Wolff III 01:16
[No subject] Bosko Vukov 07:36
Concurrency problem Dag Gullberg 10:58
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd Gaetano Mendola 11:18
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Mike Rylander 14:49
Re: Postgres Doubt John DeSoi 15:50
Re: Concurrency problem Tom Lane 17:15
How to convert 3 colums to timestamp with timezone Jens Arnfelt 20:50
Re: Stable function semantics (was Re: Mislabeled timestamp functions) Tom Lane 21:27
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Greg Stark 21:49
Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) Tom Lane 22:37
Re: How to convert 3 colums to timestamp with timezone Bruno Wolff III 23:42

Oct. 4, 2004

Thread Author Time
Difference between IN and JOIN Markus Bertheau 08:39
Re: Concurrency problem Dag Gullberg 11:35
Re: Concurrency problem Magnus Hagander 11:39
Re: Difference between IN and JOIN Tom Lane 14:17
Re: Difference between IN and JOIN Markus Bertheau 14:23

Oct. 5, 2004

Thread Author Time
Stuffing six separate columns into a single array? C. Bensend 03:56
Re: Stuffing six separate columns into a single array? Michael Fuhr 07:04
Re: Howto turn an integer into an interval? Achilleus Mantzios 11:44
Howto turn an integer into an interval? Erik Wasser 12:07
Re: Howto turn an integer into an interval? Pierre-Frédéric Caillaud 12:38
Re: Stuffing six separate columns into a single array? C. Bensend 13:26
Using timestamp in function Silke Trissl 15:37
Re: Using timestamp in function Tom Lane 16:06
Re: Using timestamp in function Michael Fuhr 16:19
Stored Procedures returning a RECORD Kent Anderson 17:52
Re: Stored Procedures returning a RECORD Jeff Eckermann 20:41

Oct. 6, 2004

Thread Author Time
Regex Theo Galanakis 00:52
Database Backup sreejith s 02:39
Re: Regex Tom Lane 03:36
Re: Howto turn an integer into an interval? sad 05:01
Re: Regex Theo Galanakis 05:44
Re: Howto turn an integer into an interval? Erik Wasser 08:13
Re: Database Backup sklassen 15:19
Table locks Jaime Casanova 20:36

Oct. 7, 2004

Thread Author Time
Query from different Database Abdul Wahab Dahalan 08:52
Re: Query from different Database Robert Creager 14:05
Re: Query from different Database Jaime Casanova 20:58

Oct. 8, 2004

Thread Author Time
help on a query Michelle Murrain 03:03
Re: help on a query Thomas F.O'Connell 03:10
Re: help on a query sad 04:44
Re: help on a query CHRIS HOOVER 13:02
Re: help on a query Achilleus Mantzios 13:03
Re: help on a query Thomas F.O'Connell 15:06
Re: help on a query Michelle Murrain 15:19
Record Count sreejith s 17:51
Re: Record Count Michael Fuhr 19:32

Oct. 9, 2004

Thread Author Time
Re: help on a query Greg Stark 03:17
Impact of foreign keys on a simple count(*) ? C. Bensend 03:37
Re: Impact of foreign keys on a simple count(*) ? Tom Lane 03:49
Re: Impact of foreign keys on a simple count(*) ? C. Bensend 04:13
Re: SELECT with Function Paulo Nievierowski 15:11
How do FKs work? Marc G. Fournier 18:08
SQL confusion Andrew Ward 20:39
Re: SQL confusion Richard Poole 21:11
Re: SQL confusion Michael Fuhr 21:59

Oct. 10, 2004

Thread Author Time
Re: How do FKs work? Tom Lane 00:23
Re: How do FKs work? Marc G. Fournier 00:43
Re: How do FKs work? Marc G. Fournier 00:48
Re: How do FKs work? Janning Vygen 12:24
Re: How do FKs work? Marc G. Fournier 13:01
SQL doubt - Date Add sreejith s 14:19
Re: SQL doubt - Date Add Gaetano Mendola 14:36
Re: SQL doubt - Date Add Gaetano Mendola 14:37
Export tab delimited from mysql to postgres. Theo Galanakis 22:59

Browse Archives

Prev | Next