pgsql-sql since 2009-08-22 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

Aug. 22, 2009

Thread	Author	Time
Re: multiple substitution in a single replace call?	Jasen Betts	11:45

Aug. 24, 2009

Thread	Author	Time
Question about encoding	Denis BUCHER	16:42
Re: Question about encoding	Peter Eisentraut	22:42

Aug. 25, 2009

Thread	Author	Time
Re: Question about encoding	Denis BUCHER	20:16

Aug. 26, 2009

Thread	Author	Time
Selecting values from comma separated string	Nacef LABIDI	13:19
Re: Selecting values from comma separated string	A. Kretschmer	13:30
Re: Selecting values from comma separated string	Pavel Stehule	13:32
Re: Selecting values from comma separated string	Pavel Stehule	13:33
Re: Selecting values from comma separated string	Tom Lane	14:05
Re: Selecting values from comma separated string	Nacef LABIDI	14:13
Re: Selecting values from comma separated string	Pavel Stehule	14:58
Re: Advice returning data as an array	Erik Jones	18:20

Aug. 27, 2009

Thread	Author	Time
Howto automatically define collumn names for a function result.	Andreas	11:08
Re: Howto automatically define collumn names for a function result.	Jorge Godoy	11:25
WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable	rawi	11:59
resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable	rawi	14:16
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable	Tom Lane	15:18
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable	Rob Sargent	15:27
Data audit trail techniques in postgresql	Nathaniel Smith	16:28
Re: Data audit trail techniques in postgresql	Alvaro Herrera	17:36
Re: [SQL] Data audit trail techniques in postgresql	Rob Sargent	18:31
Re: [SQL] Data audit trail techniques in postgresql	Alvaro Herrera	19:32
Re: [SQL] Data audit trail techniques in postgresql	Rob Sargent	20:30

Aug. 28, 2009

Thread	Author	Time
hopeless, SQL not resolved yet	rawi	13:52
Re: Data audit trail techniques in postgresql	Nathaniel Smith	14:39
recursively isolate pedigrees, based only on person_id, mother_id and father_id	rawi	15:10
Re: recursively isolate pedigrees, based only on person_id, mother_id and father_id	Rob Sargent	16:19

Aug. 29, 2009

Thread	Author	Time
NEED HELP COPY TO DYNAMIC OUTPUT FILE	Yogi Rizkiadi	22:02

Aug. 30, 2009

Thread	Author	Time
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE	Pavel Stehule	06:51
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE	Tom Lane	15:53
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE	Pavel Stehule	15:56
Searching for byte values within a bytea field	db1981	19:15

Aug. 31, 2009

Thread	Author	Time
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE	Yogi Dwianandono Rizkiadi	05:47

Sept. 1, 2009

Thread	Author	Time
PostgreSQL Function: how to know the number of the returned results of the Query	bilal ghayyad	00:53
Re: PostgreSQL Function: how to know the number of the returned results of the Query	Harun Bolat	05:31
Re: PostgreSQL Function: how to know the number of the returned results of the Query	Pavel Stehule	05:35
Plpgsql: Assign regular expression match to variable	Leif B. Kristensen	12:01
Re: Plpgsql: Assign regular expression match to variable	Ian Barwick	12:36
Re: Plpgsql: Assign regular expression match to variable	Leif B. Kristensen	12:56
Odd sort behaviour	Rob Sargent	21:01
Re: Odd sort behaviour	Scott Marlowe	21:38
Re: Odd sort behaviour	Rob Sargent	22:31
Re: Odd sort behaviour	Greg Stark	23:04
Re: Odd sort behaviour	Rob Sargent	23:22

Sept. 2, 2009

Thread	Author	Time
How to create Function which retruns username and password	venkat	08:05
Re: How to create Function which retruns username and password	A. Kretschmer	08:33
Min and max element of an array column	Gianvito Pio	10:58
Re: Min and max element of an array column	A. Kretschmer	11:26
Question	aymen marouani	14:17
Question	aymen marouani	14:28
Re: Question	Rob Sargent	15:19
Re: Question	Ross J. Reedstrom	15:28

Sept. 3, 2009

Thread	Author	Time
Re: Odd sort behaviour	Lew	00:50
Re: Question	A. Kretschmer	06:32

Sept. 4, 2009

Thread	Author	Time
LIMIT 1; The Integer part only	bilal ghayyad	00:49
Re: LIMIT 1; The Integer part only	Steve Crawford	01:02
Re: LIMIT 1; The Integer part only	Christophe Pettus	01:28
Adding ENUM Type	Simon Bateman	05:36

Sept. 5, 2009

Thread	Author	Time
Substring	bilal ghayyad	00:45
Re: Substring	Raj Mathur	02:32
How to simulate (run) the function	bilal ghayyad	02:43
Re: How to simulate (run) the function	Scott Marlowe	02:51
Re: Substring	Frank Bax	04:10
Re: Substring	Raj Mathur	04:27

Sept. 7, 2009

Thread	Author	Time
Re: Substring	Fernando Hevia	18:36
Postgresql PostGIS installation on Widows Server 2003	venkat	19:53

Sept. 9, 2009

Thread	Author	Time
trigger failed to identify the partions	Sridhar Reddy Ratna	09:26
Re: trigger failed to identify the partions	Richard Huxton	10:05
Re: trigger failed to identify the partions	Sridhar Reddy Ratna	11:05
Differences between bit string constant sintax	Oliveiros C,	11:10
how to: refer to select list calculations other places in the calculations.	Little, Douglas	13:27
Re: trigger failed to identify the partions	Richard Huxton	14:35
Encryption in the tables of a Postgres 7.3.2 database	jtayamai	16:09

Sept. 10, 2009

Thread	Author	Time
Re: Differences between bit string constant sintax	Jasen Betts	09:25
Trapping 'invalid input syntax for integer'	Mario Splivalo	12:23
Talend : Talend Integration Suite vs Talend Open Studio	Rstat	13:00
Re: Trapping 'invalid input syntax for integer'	Marcin Krawczyk	13:54
Re: Trapping 'invalid input syntax for integer'	Mario Splivalo	14:13
Re: how to: refer to select list calculations other places in the calculations.	Rob Sargent	16:32

Sept. 11, 2009

Thread	Author	Time
Re: Encryption in the tables of a Postgres 7.3.2 database	Richard Huxton	07:26
Re: Talend : Talend Integration Suite vs Talend Open Studio	Tguru	09:47
Serious problems with non-primary foreign keys	Janne	13:26
about pg_proc (column pronamespace)	Gerardo Herzig	17:57
Re: about pg_proc (column pronamespace)	Tom Lane	18:12
Re: about pg_proc (column pronamespace)	Gerardo Herzig	18:14
its posible to use a 2 column returning function as a subquery?	Gerardo Herzig	20:16
Re: its posible to use a 2 column returning function as a subquery?	Tom Lane	21:44

Sept. 13, 2009

Thread	Author	Time
schema proxying virtual database	Rajesh Kumar Mallah	15:07
Re: Serious problems with non-primary foreign keys	Adrian Klaver	18:37

Sept. 14, 2009

Thread	Author	Time
CHECK constraint on multiple tables	Mario Splivalo	13:24
Re: CHECK constraint on multiple tables	Ries van Twisk	13:27
Re: CHECK constraint on multiple tables	Mario Splivalo	13:58
Re: CHECK constraint on multiple tables	Tom Lane	14:18
Re: CHECK constraint on multiple tables	Mario Splivalo	14:20
ordered by join? ranked aggregate? how to?	wstrzalka	14:25
Re: CHECK constraint on multiple tables	Thomas Kellerer	17:00

Sept. 15, 2009

Thread	Author	Time
Re: ordered by join? ranked aggregate? how to?	A. Kretschmer	07:49
Re: ordered by join? ranked aggregate? how to?	A. Kretschmer	07:56
Re: ordered by join? ranked aggregate? how to?	wstrzalka	08:10
Re: ordered by join? ranked aggregate? how to?	wstrzalka	08:12
hardware information	std pik	09:45
Re: hardware information	Martie Krukkeland	14:38

Sept. 16, 2009

Thread	Author	Time
Re: CHECK constraint on multiple tables	Rob Sargent	03:34
Re: hardware information	Psicopunk	09:01
CREATE INDEX on column of type 'point'	Mario Splivalo	20:19

Sept. 17, 2009

Thread	Author	Time
Hibernate, web application and only one sequence for all primary keys	rawi	12:47
extracting from epoch values in pgsql	Gavin McCullagh	13:01
Re: Hibernate, web application and only one sequence for all primary keys	rawi	13:07
Re: Hibernate, web application and only one sequence for all primary keys	Leo Mannhart	13:11
Re: Hibernate, web application and only one sequence for all primary keys	Tom Lane	13:59
Re: Hibernate, web application and only one sequence for all primary keys	rawi	14:37
Re: Hibernate, web application and only one sequence for all primary keys	rawi	14:47
Re: Hibernate, web application and only one sequence for all primary keys	Kenneth Marshall	14:54
Re: Hibernate, web application and only one sequence for all primary keys	rawi	14:55
Re: Hibernate, web application and only one sequence for all primary keys	Rob Sargent	15:05
Re: Hibernate, web application and only one sequence for all primary keys	Leo Mannhart	15:07
Rules, functions and RETURNING	Nico Mandery	15:35
extracting from epoch values in pgsql	Gavin McCullagh	16:44
Re: extracting from epoch values in pgsql	Frank Bax	17:01
Re: extracting from epoch values in pgsql	Gavin McCullagh	17:30
Re: extracting from epoch values in pgsql	Osvaldo Kussama	17:32
Re: extracting from epoch values in pgsql	Gavin McCullagh	17:34
Re: extracting from epoch values in pgsql	Gavin McCullagh	17:37
Re: extracting from epoch values in pgsql	Frank Bax	17:38
Re: extracting from epoch values in pgsql	Kenneth Marshall	17:39

Sept. 18, 2009

Thread	Author	Time
Re: Hibernate, web application and only one sequence for all primary keys	Craig Ringer	02:01
Re: Rules, functions and RETURNING	Adrian Klaver	02:40
Thank you all for your help...	rawi	07:41
Re: Rules, functions and RETURNING	Nico Mandery	14:51

Sept. 19, 2009

Thread	Author	Time
Re: Hibernate, web application and only one sequence for all primary keys	Lew	02:38

Sept. 21, 2009

Thread	Author	Time
Working slow	Judith Altamirano	13:58

Sept. 22, 2009

Thread	Author	Time
Re: Working slow	Scott Marlowe	01:56
Re: Working slow	Rob Sargent	02:45
selecting latest record	Louis-David Mitterrand	09:44
Re: selecting latest record	Pavel Stehule	09:56
Re: selecting latest record	Louis-David Mitterrand	10:02
Re: selecting latest record	A. Kretschmer	10:08
Re: selecting latest record	Rob Sargent	14:09
Data integration tool in Chinese?	hfdabler	14:23
AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks	Bryce Nesbitt	16:41
AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks (formatted better)	Bryce Nesbitt	16:55
Re: AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks (formatted better)	Tom Lane	17:35

Sept. 23, 2009

Thread	Author	Time
Re: AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks (formatted better) 📎	Bryce Nesbitt	00:10
Re: Data integration tool in Chinese?	Rob Sargent	04:07
Re: Data integration tool in Chinese?	J. Roeleveld	08:02
SQL Subqueries on each result row	AnthonyV	09:43
Re: SQL Subqueries on each result row	Jim	16:33
SQL moving window averages/statistics	Kai Carter	23:04

Sept. 24, 2009

Thread	Author	Time
Re: SQL Subqueries on each result row	Mark J Camilleri	07:43
simple (?) join	Gary Stainburn	15:16
Re: simple (?) join	Oliveiros C,	17:17
Re: simple (?) join	Oliveiros C,	17:26
Re: simple (?) join	David W Noon	18:46
Re: simple (?) join 📎	justin	20:15
Re: simple (?) join	David W Noon	21:21

Sept. 25, 2009

Thread	Author	Time
Re: simple (?) join	Raj Mathur	03:06
Re: simple (?) join	Oliveiros C,	11:00
Re: simple (?) join	Claus Guttesen	22:36

Sept. 26, 2009

Thread	Author	Time
Re: simple (?) join 📎	justin	18:53
Re: simple (?) join 📎	justin	18:54
Re: simple (?) join	David W Noon	19:53
Re: simple (?) join 📎	justin	20:15

Sept. 28, 2009

Thread	Author	Time
Re: simple (?) join	Gary Stainburn	11:02
Re: simple (?) join	Oliveiros C,	11:14
Re: simple (?) join	David W Noon	11:27
Re: simple (?) join	Gary Stainburn	13:43

Sept. 29, 2009

Thread	Author	Time
Common table expression - parsing questions	the6campbells	02:54
Disable Constraints in Postgresql 8.4	Jyoti Seth	08:52
Re: Disable Constraints in Postgresql 8.4	Tom Lane	14:13

Oct. 1, 2009

Thread	Author	Time
Pg_Restore with --clean option	Jyoti Seth	05:14
Re: Pg_Restore with --clean option	Peter Eisentraut	06:05
Can i customize null-padding for outer joins?	Shruthi A	06:19
Re: Can i customize null-padding for outer joins?	Scott Marlowe	06:22
Re: Pg_Restore with --clean option	Scott Marlowe	06:37
Re: Can i customize null-padding for outer joins?	A. Kretschmer	06:40

Oct. 2, 2009

Thread	Author	Time
Need magic for a moving statistic	Andreas	01:06
Re: SQL moving window averages/statistics	Andreas	03:52
Re: Need magic for a moving statistic	A. Kretschmer	05:29
right join problem	Greenhorn	05:33
Re: right join problem	A. Kretschmer	05:45
Re: right join problem	A. Kretschmer	06:36
Re: Need magic for a moving statistic	Andreas	12:47
Re: Need magic for a moving statistic	A. Kretschmer	13:10

Oct. 4, 2009

Thread	Author	Time
Need even more magic. Now for tricky counts.	Andreas	04:08
Re: Common table expression - parsing questions	Thomas Kellerer	06:10
Re: Common table expression - parsing questions	the6campbells	13:25
reading last inserted record withoud any autoincrement field	mohammad qoreishy	14:49
Re: Common table expression - parsing questions	Tom Lane	15:00
Re: reading last inserted record withoud any autoincrement field	Osvaldo Kussama	18:37
Re: reading last inserted record withoud any autoincrement field	Rob Sargent	19:34

Oct. 5, 2009

Thread	Author	Time
Re: Common table expression - parsing questions	Lew	00:44
Re: reading last inserted record withoud any autoincrement field	Scott Marlowe	22:23

Oct. 7, 2009

Thread	Author	Time
Re: AccessExclusiveLock on CREATE TABLE REFERENCES deadlocks (formatted better)	Erik Jones	05:25

Oct. 8, 2009

Thread	Author	Time
Function Anomaly?	Gary Chambers	02:25
Re: Function Anomaly?	Richard Huxton	08:24
Pulling additional columns with aggregate	sub3	13:14
Re: Pulling additional columns with aggregate	Lennin Caro	14:44

Oct. 9, 2009

Thread	Author	Time
select result into string's array	Alberto Asuero Arroyo	07:30
Re: select result into string's array	A. Kretschmer	07:45
Re: select result into string's array	Dmitriy Igrishin	08:31

Browse Archives

Prev | Next