pgsql-sql since 2002-07-18 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 18, 2002

Thread Author Time
Re: Indexing UNIONs Josh Berkus 00:19
Re: Indexing UNIONs Bruno Wolff III 02:29
Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah. 05:42
Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah. 06:39
Re: [HACKERS] why is postgres estimating so badly? Luis Alberto Amigo Navarro 08:18
Re: how do i import my sql query result to a file Steve Brett 09:41
Re: Newbie: Creative use of LIMIT?? Richard Huxton 09:59
about Inheritance... frederik nietzsche 10:32
hints or suggestion for optimizer adrian 10:34
Re: how do i import my sql query result to a file Robert Treat 14:13
Re: How to find out if an index is unique? Christoph Haller 16:22
Re: Indexing UNIONs Josh Berkus 17:30
how do i import my sql query result to a file Joseph Syjuco 21:47

July 19, 2002

Thread Author Time
Re: how do i import my sql query result to a file Ludwig Lim 00:34
Regarding replication Charitha 06:31
Re: [SQL] id and ID in CREATE TABLE Christopher Kings-Lynne 06:55
Re: id and ID in CREATE TABLE Martijn van Oosterhout 07:20
Re: [SQL] id and ID in CREATE TABLE Josh Jore 09:09
Re: [SQL] id and ID in CREATE TABLE Tom Lane 13:31
Re: Regarding replication Josh Berkus 15:18
Adventures in PostgreSQL Josh Berkus 15:26
Re: [SQL] id and ID in CREATE TABLE Bruce Momjian 15:36
Re: [GENERAL] id and ID in CREATE TABLE 📎 Thomas Swan 15:39
Two Index Questions Josh Berkus 16:33
Re: Two Index Questions Tom Lane 16:44
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 16:53
Re: Two Index Questions Bruno Wolff III 17:00
Re: how do i import my sql query result to a file Joseph Syjuco 17:15
Re: Two Index Questions Josh Berkus 17:28
Re: [SQL] id and ID in CREATE TABLE Bruce Momjian 17:29
Re: [SQL] id and ID in CREATE TABLE Tom Lane 17:33
Re: Two Index Questions Tom Lane 17:53
Re: Two Index Questions Bruno Wolff III 17:56
Re: Two Index Questions Josh Berkus 18:12
Re: Two Index Questions Bruce Momjian 18:27
Re: Two Index Questions Tom Lane 18:35
Is it possible to use a field from another table as part of a query? Patrick Hatcher 18:37
Re: Is it possible to use a field from another table as part of a query? Josh Berkus 18:54
Re: Two Index Questions Josh Berkus 18:58
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 19:15
Re: Is it possible to use a field from another table as part of a Patrick Hatcher 19:26
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 19:27
Re: [SQL] id and ID in CREATE TABLE Stephan Szabo 19:47
Re: [SQL] id and ID in CREATE TABLE Tom Lane 20:16

July 20, 2002

Thread Author Time
id and ID in CREATE TABLE stefan 07:15
Re: id and ID in CREATE TABLE stefan 07:39
Re: id and ID in CREATE TABLE stefan 11:33
Re: [SQL] id and ID in CREATE TABLE stefan 20:01

July 21, 2002

Thread Author Time
7.3 features and enhancements mark carew 00:11

July 22, 2002

Thread Author Time
Float / Numeric ? Rudi Starcevic 00:06
"no wait" in locks Daniel Stüwe 00:50
"no wait" in locks Daniel Stüwe 00:54
"no wait" option for locks Daniel Stüwe 01:10
Re: 'no wait' option for locks mallah 03:26
Re: SQL problem with aggregate functions. Hubert depesz Lubaczewski 08:26
Editor for pgsql Elielson Fontanezi 12:36
Re: 7.3 features and enhancements Bruno Wolff III 13:53
FATAL 1 Ian Cass 14:55
[NOVICE] SET CONSTRAINTS question... Michael Paesold 15:26
Re: [NOVICE] SET CONSTRAINTS question... Stephan Szabo 15:40
Free 4GL Compiler, Informix-Postgress support Ecitizen 16:11
Re: Editor for pgsql Josh Berkus 16:27
interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech 16:49
interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech 16:58
Re: Float / Numeric ? Jan Wieck 17:13
Re: interval syntax change from 7.1.2 to 7.2.1? Gaetano Mendola 17:37
Queries not using Index Daryl Herzmann 18:59
Queries not using Index Daryl Herzmann 19:07
Re: Editor for pgsql James Orr 20:09
Re: Editor for pgsql Josh Berkus 20:53
Re: Editor for pgsql Marc Spitzer 23:07
Re: [SQL] Editor for pgsql Roberto Mello 23:32

July 23, 2002

Thread Author Time
Re: Editor for pgsql Josh Berkus 00:41
Re: Editor for pgsql Roberto Mello 05:45
pg_dump and sequences Achilleus Mantzios 08:27
Re: pg_dump and sequences Achilleus Mantzios 08:33
Re: Queries not using Index Gaetano Mendola 12:56
Scan SQL Sandro Joel Eller 13:11
Re: Queries not using Index Daryl Herzmann 13:26
Re: Editor for pgsql Andreas Joseph Krogh 14:13
Re: Scan SQL Sandro Joel Eller 14:34
Case in-sensitive Carmen Wai 14:35
Re: Case in-sensitive Andrew Sullivan 14:46
No command history in psql Carmen Wai 14:53
Re: Queries not using Index Stephan Szabo 15:05
Re: No command history in psql Andrew Sullivan 15:18
Re: Editor for pgsql Josh Berkus 15:37
Re: Scan SQL Josh Berkus 15:40
Re: No command history in psql Robert Treat 16:17
Re: Queries not using Index Daryl Herzmann 16:35
Re: Queries not using Index Stephan Szabo 17:00
Re: Scan SQL Roberto Mello 17:36
Readline ... a lot of problems... Victor Hugo Germano 18:51
Re: Queries not using Index 📎 Daryl Herzmann 20:51
Re: Misunderstanding about your article entitled: Episode 2: Josh Berkus 21:47
Re: 7.3 features and enhancements Bruce Momjian 22:10
Re: Scan SQL Josh Jore 22:18
Re: FATAL 1 Bruce Momjian 23:44

July 24, 2002

Thread Author Time
Re: Queries not using Index Stephan Szabo 00:33
Re: Queries not using Index Daryl Herzmann 00:53
Re: Queries not using Index Christopher Kings-Lynne 01:47
Re: Queries not using Index Daryl Herzmann 01:57
Re: Queries not using Index Christopher Kings-Lynne 02:09
Re: Queries not using Index Daryl Herzmann 02:24
Re: pg_dump and sequences Tom Lane 07:24
Re: FATAL 1 Ian Cass 08:57
Re: pg_dump and sequences Achilleus Mantzios 10:56
pg_restore vs. indexes 📎 daq 11:50
Problem with my query whithout double-quotes ROUWEZ Stephane 11:52
Return Primary Key from Procedure Peter Atkins 14:12
Last record Leao Torre do Vale 14:36
RES: [SQL] Queries not using Index Elielson Fontanezi 14:41
Re: RES: [SQL] Queries not using Index Stephan Szabo 15:18
Re: RES: [SQL] Queries not using Index Daryl Herzmann 15:45
Re: [SQL] Queries not using Index Christopher Kings-Lynne 15:48
RES: RES: [SQL] Queries not using Index Elielson Fontanezi 16:13
Re: RES: [SQL] Queries not using Index Phil Davey 17:12
Function using more than one database Christian Lbeck 17:24
Re: Last record Jan Wieck 17:42
Re: [SQL] Readline ... a lot of problems... Josh Berkus 17:43
Re: Last record Chris Ruprecht 17:56
Re: RES: RES: [SQL] Queries not using Index Tom Lane 18:20
Re: Problem with my query whithout double-quotes Stephan Szabo 18:24
Re: Trying to write a function... Josh Berkus 18:26
Trying to write a function... Wim 19:10
how do I change regional setting for dates? Ligia Pimentel 19:38

July 25, 2002

Thread Author Time
convert a bigint into a timestamp marc sturm 00:48
Re: [SQL] Case in-sensitive Christopher Kings-Lynne 02:21
Re: [SQL] Case in-sensitive Josh Berkus 02:27
Re: convert a bigint into a timestamp Richard Huxton 10:34
Re: Return Primary Key from Procedure Richard Huxton 10:46
use of client-side \lo_import and \lo_export commands Viacheslav Kovalchuk 12:57
Using Tables from another database. Rogério Baldini das Neves 13:36
Re: how do I change regional setting for dates? Robert Treat 14:26
Re: Last record omid omoomi 16:48
queries got slower using 7.1.3 Nathan Suderman 16:55
problem with plpgsql trigger function: parse error near "" [email protected] 17:20
Re: Using Tables from another database. omid omoomi 17:32
Re: Using Tables from another database. Bruno Wolff III 17:36
Re: Using Tables from another database. Reinoud van Leeuwen 17:43
Re: problem with plpgsql trigger function: parse error near "" Stephan Szabo 18:06
Re: problem with plpgsql trigger function: parse error near "" Jan Wieck 18:06

July 26, 2002

Thread Author Time
Change size of a field ROUWEZ Stephane 11:42
Re: Change size of a field Achilleus Mantzios 12:49
Re: Change size of a field Achilleus Mantzios 13:20
set DateStyle to 'SQL' Elielson Fontanezi 13:27
Re: Using Tables from another database. D'Arcy J.M. Cain 13:55
RES: [GENERAL] set DateStyle to 'SQL' Elielson Fontanezi 14:42
RES: set DateStyle to 'SQL' Elielson Fontanezi 16:56
Numeric Style format Elielson Fontanezi 17:09
Re: set DateStyle to 'SQL' Roberto João Lopes Garcia 18:16
1 milion data insertion Elielson Fontanezi 18:34
Re: 1 milion data insertion Marc Spitzer 18:46
Re: 1 milion data insertion Andrew Sullivan 18:46
Re: 1 milion data insertion Chris Albertson 19:15
Re: Function using more than one database Roberto Mello 21:45
Re: RES: [GENERAL] set DateStyle to 'SQL' Roberto Mello 21:53

July 27, 2002

Thread Author Time
Alter column Thiemo Kellner 01:46
using LIMIT only on primary table Dan Langille 21:26

July 28, 2002

Thread Author Time
performance difference in count(1) vs. count(*)? Markus Bertheau 15:50
Re: performance difference in count(1) vs. count(*)? Tom Lane 17:02
Re: using LIMIT only on primary table Lee Harr 18:13
Abbr. for TIMESTAMP WITHOUT TIME ZONE? Josh Berkus 23:53

July 29, 2002

Thread Author Time
Re: Problem with my query whithout double-quotes Keith Gray 03:34
Re: Abbr. for TIMESTAMP WITHOUT TIME ZONE? Tom Lane 06:11
RES: The best book Elielson Fontanezi 11:34
RES: The best book Elielson Fontanezi 11:44
RES: [SQL] RES: set DateStyle to 'SQL' Elielson Fontanezi 11:57
How to get binary data from pgsql function MaksimRomanov 13:47
How to optimize SQL query ? Milosz Krajewski 14:50
Re: RES: [SQL] RES: set DateStyle to 'SQL' Roberto Mello 16:44
Returning PK of first insert for second insert use. Peter Atkins 17:43
Returning PK of first insert for second insert use. Peter Atkins 18:32
Re: Returning PK of first insert for second insert use. Ken Corey 18:59
Re: Returning PK of first insert for second insert use. Peter Atkins 19:52
Decision support query inefficiencies ... Gunther Schadow 20:00
Re: Returning PK of first insert for second insert use. Ken Corey 20:04
Re: Returning PK of first insert for second insert use. Peter Atkins 20:20
Re: Decision support query inefficiencies ... Tom Lane 20:39
Extremely slow query Patrick Hatcher 23:32

July 30, 2002

Thread Author Time
Re: Returning PK of first insert for second insert use. Christopher Kings-Lynne 01:42
Re: Extremely slow query Christopher Kings-Lynne 02:00
contrib/dblink suggestion Bhuvan A 06:51
Re: Change size of a field ROUWEZ Stephane 08:07
Group And Sort After Union cnliou 08:46
Is login_cnt is reserved attribute name? Rajesh Kumar Mallah. 12:38
Re: contrib/dblink suggestion Bruce Momjian 15:26
Re: contrib/dblink suggestion Joe Conway 15:35
Delete a FOREIGN KEY Marcelo Henrique da Silva 17:38
formating numeric values Elielson Fontanezi 19:20
Re: Delete a FOREIGN KEY Stephan Szabo 19:23
COUNT DISTINCT? Josh Berkus 21:27
Re: COUNT DISTINCT? Stephan Szabo 21:45
Re: COUNT DISTINCT? Josh Berkus 22:52

July 31, 2002

Thread Author Time
Re: contrib/dblink suggestion Bhuvan A 04:30
Transitive Closure Suhas Joshi 04:50
Re: 3-tier John Gunther 10:42
3-tier Elielson Fontanezi 11:28
Re: [SQL] 3-tier Achilleus Mantzios 12:26
SQL syntax Mindaugas Riauba 13:16

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31