pgsql-sql since 2004-03-03 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 7 8 9 10 11 12 13 15 16 17 18 19 21 22 23 24 25 26 27 28 29 30 31

March 3, 2004

Thread Author Time
Re: User defined types -- Social Security number... Tom Hebbron 01:20
oracle decode() Andreas Schmitz 10:48
Re: oracle decode() Richard Huxton 12:51
Encoding bytea Achilleus Mantzios 13:12
Re: Encoding bytea Joe Conway 22:59

March 4, 2004

Thread Author Time
calling function William Anthony Lim 06:29
Re: calling function Tom Lane 06:40
Re: Encoding bytea Achilleus Mantzios 07:54
sub-select parameter problem Philippe Lang 11:20
Re: sub-select parameter problem Richard Huxton 11:51
Re: sub-select parameter problem Christoph Haller 12:53
How to avoid (stop) a endless loop in a trigger Rodrigo Sakai 14:54
Re: How to avoid (stop) a endless loop in a trigger Oliver Elphick 15:13
query optimization Charles Hauser 17:56
debugging query to put message in pg logfile? george young 20:32
Re: returning a recordset from PLpg/SQL Radu-Adrian Popescu 21:01
Re: query optimization Tom Lane 21:15
Re: debugging query to put message in pg logfile? Tom Lane 21:35

March 5, 2004

Thread Author Time
Re: debugging query to put message in pg logfile? george young 15:23
Re: query optimization Jonathan M. Gardner 16:28
Re: Triggers Jonathan M. Gardner 16:32
Re: VIEW on lookup table Jonathan M. Gardner 16:39
Read bytea column from table and convert into base64..... beyaNet Consultancy 23:59

March 7, 2004

Thread Author Time
Re: VIEW on lookup table JJ Gabor 13:40

March 8, 2004

Thread Author Time
designer tool connect to PostgreSQL azwa 02:13
Re: designer tool connect to PostgreSQL Yasir Malik 03:54
Re: Read bytea column from table and convert into base64..... Achilleus Mantzios 07:24
Re: designer tool connect to PostgreSQL Silke Trissl 08:00
Login information in system tables Daniel Doorduin 12:46
Re: Login information in system tables Radu-Adrian Popescu 12:49
Simple SQL question Daniel Henrique Alves Lima 14:10
Functional index and string concatenation Daniel Henrique Alves Lima 15:19
Re: Functional index and string concatenation Edmund Bacon 15:28
Re: Functional index and string concatenation Tom Lane 15:48
Trying to make efficient "all vendors who can provide all items" terry 16:02
Re: Functional index and string concatenation Daniel Henrique Alves Lima 16:02
Re: Functional index and string concatenation Richard Huxton 17:38
Re: Trying to make efficient "all vendors who can provide all items" terry 19:23
Re: Trying to make efficient "all vendors who can provide all items" Matt Chatterley 20:40
Re: Trying to make efficient "all vendors who can provide all items" terry 20:45

March 9, 2004

Thread Author Time
Re: Trying to make efficient "all vendors who can provide all items" Christopher Browne 03:20
Re: Simple SQL question Daniel Henrique Alves Lima 04:21
ANALYZE error David Witham 04:22
Re: ANALYZE error Tom Lane 04:55
Re: ANALYZE error Iain 05:15
Re: Simple SQL question Iain 05:28
Re: Simple SQL question Iain 05:37
Help to simplify sample query Daniel Henrique Alves Lima 05:41
Re: Simple SQL question Daniel Henrique Alves Lima 05:43
Re: Help to simplify sample query Tomasz Myrta 06:24
Re: Help to simplify sample query Tom Lane 06:27
Re: designer tool connect to PostgreSQL BenLaKnet 07:53
Re: Help to simplify sample query Daniel Henrique Alves Lima 12:51
Re: Help to simplify sample query Daniel Henrique Alves Lima 13:14
Re: Trying to make efficient "all vendors who can provide all items" terry 13:37
currval() without specifying the sequence name ow 13:50
Re: currval() without specifying the sequence name Achilleus Mantzios 14:10
Re: currval() without specifying the sequence name ow 14:53
Re: Trying to make efficient "all vendors who can provide all items" Michael Glaesemann 14:58
Re: currval() without specifying the sequence name Achilleus Mantzios 15:09
Re: currval() without specifying the sequence name Richard Huxton 15:14
Re: Dramatic slowdown of sql when placed in a function Jeff Boes 15:17
Re: currval() without specifying the sequence name Tom Lane 16:10
Re: currval() without specifying the sequence name ow 16:36
Re: Help to simplify sample query Daniel Henrique Alves Lima 20:13
Re: Help to simplify sample query Bruno Wolff III 20:18
Re: bytea or blobs? Richard Huxton 21:02
Re: Dramatic slowdown of sql when placed in a function Mike Moran 21:21
correlated multi-set update? Marty Scholes 21:48
Converting query to view - duplicate fields Richard Grosse 22:40
Re: correlated multi-set update? Stephan Szabo 23:14

March 10, 2004

Thread Author Time
Re: Converting query to view - duplicate fields Stephan Szabo 02:17
pg_hba.conf azwa 04:12
Re: correlated multi-set update? Bruno Wolff III 04:52
Re: pg_hba.conf azwa 05:39
Database reporting tool azwa 06:17
Re: Database reporting tool Jerome Alet 06:52
changing constraints David 12:27
Re: changing constraints Paul Thomas 13:07
Re: changing constraints Achilleus Mantzios 13:41
Re: changing constraints Richard Huxton 13:51
Break a Report in Run Time Jander Rebelo Luiz 14:29
Re: changing constraints David 15:57
randomized order in select? Enver ALTIN 16:48
Alter table David 16:58
Changing primary keys David 17:17
Re: Alter table scott.marlowe 17:55
Re: designer tool connect to PostgreSQL Robert Treat 18:18
Break a report in Run Time Jander 18:23
Re: randomized order in select? Bruno Wolff III 19:02
Re: randomized order in select? scott.marlowe 19:06
Inserting data in a table using sub-selects Andreas Joseph Krogh 19:52
Tsearch2 question: getting histogram of the vector elements Rajesh Kumar Mallah 19:54
Re: Inserting data in a table using sub-selects Stephan Szabo 20:49
Re: Inserting data in a table using sub-selects] Marty Scholes 20:56
Re: Changing primary keys Jonathan Gardner 22:06
Re: Break a report in Run Time Jonathan Gardner 22:09
Re: Inserting data in a table using sub-selects] Andreas Joseph Krogh 22:33
Re: Converting query to view - duplicate fields - solved Richard Grosse 22:51
About pg_dump Daniel Henrique Alves Lima 23:00
Re: randomized order in select? Enver ALTIN 23:15

March 11, 2004

Thread Author Time
Re: designer tool connect to PostgreSQL azwa 01:51
Re: randomized order in select? Iain 05:31
Re: randomized order in select? Tom Lane 06:40
Re: Tsearch2 question: getting histogram of the vector elements Oleg Bartunov 09:01
Re: About pg_dump Rute Solipa 15:01
Re: Tsearch2 question: getting histogram of the vector elements George Essig 15:56
Re: About pg_dump Tom Lane 16:03
Re: Tsearch2 question: getting histogram of the vector elements mallah 16:03
Re: Break a report in Run Time Jonathan M. Gardner 16:22
Re: randomized order in select? scott.marlowe 16:28
Re: designer tool connect to PostgreSQL scott.marlowe 17:14
trace facility beyaNet Consultancy 17:39
Re: Break a report in Run Time Jonathan Gardner 20:14
Re: About pg_dump Daniel Henrique Alves Lima 21:13
IMPORT TOOL Louie Kwan 21:17
Problems with tsearch2: ERROR: datumGetSize: Invalid typLen 0 postgres 21:58
Re: IMPORT TOOL Chris Browne 22:14

March 12, 2004

Thread Author Time
sqlloader features azwa 09:05
where not unique Gary Stainburn 13:02
Re: where not unique Daniel Henrique Alves Lima 13:54
Re: where not unique Paul Thomas 13:57
Re: where not unique Daniel Henrique Alves Lima 14:05
SQL query --- big question??? Andrei Bintintan 14:36
Re: sqlloader features Jeff Eckermann 14:55
Re: SQL query --- big question??? Richard Huxton 15:20
pg_dump backwards compat issues tomg 19:58

March 13, 2004

Thread Author Time
function returning resultset William Anthony Lim 02:47
Object-relational features Yasir Malik 17:30

March 15, 2004

Thread Author Time
Invalid Characters Raman 10:37
Re: Invalid Characters Paul Thomas 11:42
Re: Object-relational features John DeSoi 13:28
Re: Object-relational features Yasir Malik 14:06
Re: Object-relational features Bruno Wolff III 15:07
Re: Object-relational features Stephan Szabo 15:13

March 16, 2004

Thread Author Time
Import from Ms Excel Kumar 09:43
Re: Import from Ms Excel Andrew Sullivan 11:29
Re: Import from Ms Excel Achilleus Mantzios 11:42
Re: Import from Ms Excel Andrew Sullivan 11:47
Re: Import from Ms Excel Achilleus Mantzios 12:08
Re: Import from Ms Excel Dana Hudes 12:13
conversion of postgres database to oracle cristi 12:13
could not create shared memory segment: Invalid argument beyaNet Consultancy 12:31
flat file database to postgres noor 12:33
Re: could not create shared memory segment: Invalid argument Achilleus Mantzios 12:45
Re: could not create shared memory segment: Invalid argument Dana Hudes 13:02
Re: flat file database to postgres Frank Finner 13:30
Re: conversion of postgres database to oracle Andrew Sullivan 13:56
Can statement_timeout emulated NOWAIT? Luis P Caamano 13:58
Re: flat file database to postgres Tatsuo Ishii 14:04
Re: [SQL] could not create shared memory segment: Invalid argument Theodore Petrosky 14:31
Re: Can statement_timeout emulated NOWAIT? Tom Lane 15:48
Re: Can statement_timeout emulated NOWAIT? Bruce Momjian 15:56
Re: Import from Ms Excel Jeff Eckermann 16:13
Re: Can statement_timeout emulated NOWAIT? Luis P Caamano 16:33
working with unix timestamp Gary Stainburn 16:54
Re: working with unix timestamp Tom Lane 17:52
Re: working with unix timestamp Frank Finner 17:56

March 17, 2004

Thread Author Time
Line length in pl/pgsql function David Olbersen 00:47
Re: Line length in pl/pgsql function Tom Lane 05:35
Re: Line length in pl/pgsql function Richard Huxton 09:27
Re: working with unix timestamp Gary Stainburn 11:17
Re: Line length in pl/pgsql function 📎 David Olbersen 19:50
Re: Line length in pl/pgsql function David Olbersen 19:52
Re: Line length in pl/pgsql function Tom Lane 20:03
Re: Line length in pl/pgsql function David Olbersen 20:07
Re: Line length in pl/pgsql function David Olbersen 20:37

March 18, 2004

Thread Author Time
Date format issue Raman 05:37
Re: Date format issue Stephan Szabo 05:58
perfomance question sad 06:41
Re: Date format issue Tom Lane 15:55
Re: perfomance question Josh Berkus 18:38

March 19, 2004

Thread Author Time
Re: perfomance question sad 06:27
Re: perfomance question Adam Ruth 07:14
inverse of "day of year" Martin Marques 12:06
psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Kumar 12:39
triggers on commit Erik Thiele 13:04
Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Martin Marques 13:05
Re: inverse of "day of year" Robert Creager 13:47
Re: psql: FATAL 1: IDENT authentication failed for user error Devrim GUNDUZ 14:23
Re: inverse of "day of year" Tom Lane 15:10
Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Tom Lane 15:12
Re: triggers on commit Tom Lane 15:13
CREATE TABLE LIKE question Robert Creager 15:26
Re: triggers on commit Erik Thiele 15:27

March 21, 2004

Thread Author Time
Re: Import from Ms Excel Hans de Bruin 16:25

March 22, 2004

Thread Author Time
special integrity constraints Erik Thiele 09:20
Re: special integrity constraints Achilleus Mantzios 10:13
Re: special integrity constraints Erik Thiele 10:26
Re: special integrity constraints Bruno Wolff III 11:26
Re: inverse of "day of year" Martin Marques 11:32
Re: special integrity constraints Achilleus Mantzios 11:40
Re: inverse of "day of year" Bruno Wolff III 12:50
Re: special integrity constraints Erik Thiele 13:10
Re: inverse of "day of year" Martin Marques 13:14
Re: special integrity constraints Stephan Szabo 14:21
Re: special integrity constraints Bruno Wolff III 15:12
Re: inverse of "day of year" Bruno Wolff III 15:18
Re: inverse of "day of year" Dana Hudes 15:56
Re: special integrity constraints Erik Thiele 16:21

Browse Archives

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