pgsql-sql since 2004-03-11 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

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
Re: special integrity constraints Erik Thiele 16:25
Re: special integrity constraints Stephan Szabo 16:34

March 23, 2004

Thread Author Time
Re: [SQL] special integrity constraints Bruno Wolff III 00:34
function definition documentation Gregory S. Williamson 02:16
Sorting an aggregated column David Witham 03:26
Re: Sorting an aggregated column Tom Lane 05:17
Re: Sorting an aggregated column David Witham 07:17
Re: special integrity constraints Achilleus Mantzios 07:26
Re: function definition documentation Richard Huxton 08:08
Newbie Query question Marcel Loose 09:56
Re: inverse of "day of year" Martin Marques 14:04
fine grained trigger time specification... Erik Thiele 14:19
Re: Sorting an aggregated column Tom Lane 14:54
Re: fine grained trigger time specification... Bruno Wolff III 16:17
Re: fine grained trigger time specification... Erik Thiele 16:56
Re: fine grained trigger time specification... Stephan Szabo 17:22
Re: could not create shared memory segment: Invalid argument xvx 18:30
Re: Database reporting tool Bill 18:51
Re: [GENERAL] PHP or JSP? That is the question. Guy Fraser 19:05
SQL Query beyaNet Consultancy 20:02
Re: SQL Query Bruno Wolff III 20:46
move forward 0 from foo; Chester Kustarz 21:13
Re: move forward 0 from foo; Tom Lane 22:37

March 24, 2004

Thread Author Time
Re: function definition documentation Gregory S. Williamson 00:04
Invalid Unicode Character Sequence found Bulatovic Natasa 12:24

March 25, 2004

Thread Author Time
order of results Gregor Rot 13:23
Using Bounding Box as a where predicate Okeh, Sam 19:21

March 26, 2004

Thread Author Time
how to turn off autocommit in psql Kemin Zhou 01:25
Re: how to turn off autocommit in psql Paul Thomas 08:59
date_part stored procs Tsoloane Moahloli 14:19
Re: Newbie Query question Rod Taylor 14:49
autocommit Kemin Zhou 19:31
Re: Invalid Unicode Character Sequence found Tom Lane 21:43
Re: order of results Bruno Wolff III 21:53
Re: date_part stored procs Tom Lane 23:03

March 27, 2004

Thread Author Time
Re: autocommit Tom Lane 03:23
Re: Invalid Unicode Character Sequence found Markus Bertheau 10:02

March 28, 2004

Thread Author Time
Re: Slow sub-selects, max and count(*) Greg Stark 06:31

March 29, 2004

Thread Author Time
Re: date_part stored procs Tsoloane Moahloli 07:30
Re: Invalid Unicode Character Sequence found Bulatovic Natasa 07:33
Question on pgsql trigger Jon Poulton 17:12
Re: Slow sub-selects, max and count(*) Josh Berkus 21:47

March 30, 2004

Thread Author Time
Entered data appears TWICE in table!!? Ron M. 19:29
plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 22:08

March 31, 2004

Thread Author Time
SQL Spec Compliance Questions Josh Berkus 04:50
Re: [SQL] SQL Spec Compliance Questions Tom Lane 05:18
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 06:14
Re: plpgsql vs. SQL in stored procedures Christopher Browne 08:31
Timestamp manipulation Stephen Quinney 10:41
Re: plpgsql vs. SQL in stored procedures Ivan Sergio Borgonovo 11:07
Re: plpgsql vs. SQL in stored procedures Richard Huxton 12:06
Is it normal that functions are so much faster than inline queries Olivier Hubaut 12:28
Re: Is it normal that functions are so much faster than inline queries Tom Lane 15:33
Simple insert not returning Kyle 18:06
left join on a view takes significantly more time. Manuel Sugawara 18:55
Re: [SQL] SQL Spec Compliance Questions Josh Berkus 22:41
Re: left join on a view takes significantly more time. Josh Berkus 23:49

April 1, 2004

Thread Author Time
Re: Is it normal that functions are so much faster than inline queries Olivier Hubaut 07:07
Re: DB question - Merging data from one table to another. malia, sean 15:27
Getting the ranks of results from a query abhi 16:05
Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:20
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:36
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:48
Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway 21:51
Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus 21:57

April 2, 2004

Thread Author Time
Re: SQL Spec Compliance Questions Joe Conway 07:03
Re: SQL Spec Compliance Questions Josh Berkus 16:38
Re: SQL Spec Compliance Questions Joe Conway 16:48
Re: SQL Spec Compliance Questions Josh Berkus 16:53
Re: [SQL] SQL Spec Compliance Questions Tom Lane 17:47

April 3, 2004

Thread Author Time
Re: order of results Gregor Rot 15:08
Re: SQL Spec Compliance Questions Peter Eisentraut 23:24
Re: [SQL] SQL Spec Compliance Questions Peter Eisentraut 23:26

April 5, 2004

Thread Author Time
oracle varray functionality? Postgres User 15:45
Function To Log Changes Gavin 17:01
Re: Function To Log Changes Josh Berkus 17:18
Re: Function To Log Changes Tom Lane 17:39
group by not returning sorted rows Bret Hughes 21:55
Re: Entered data appears TWICE in table!!? Jeff Eckermann 22:33
Re: group by not returning sorted rows Tom Lane 22:34
Re: Question on pgsql trigger Jeff Eckermann 22:34
Re: group by not returning sorted rows Stephan Szabo 22:54
Re: DB question - Merging data from one table to another. scott.marlowe 22:55

April 6, 2004

Thread Author Time
Re: Rename Schema or Script DDL only a schema Olivier Hubaut 08:17
Rename Schema or Script DDL only a schema kumar 09:02
could not devise a query plan SZŰCS Gábor 13:12
Re: Entered data appears TWICE in table!!? Jeff Eckermann 14:27
partial unique constraint Robert Treat 14:29
Re: could not devise a query plan Tom Lane 15:00
Re: partial unique constraint Stephan Szabo 15:05
Re: partial unique constraint ries 15:05
Re: partial unique constraint Tom Lane 15:17
Re: partial unique constraint Rod Taylor 15:17
Re: partial unique constraint Achilleus Mantzios 15:18
Re: partial unique constraint Paul Thomas 15:26
Re: partial unique constraint Robert Treat 16:38
Re: group by not returning sorted rows Bret Hughes 16:51
distinct values without seq scan Bret Hughes 17:06
SQL Standatd Ricardo Vaz Mannrich 18:21
Re: SQL Standatd Bruce Momjian 19:01
Re: could not devise a query plan Tom Lane 19:05

Browse Archives

Prev | Next