pgsql-sql since 2009-08-13 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. 13, 2009

Thread Author Time
Re: Month/year between two dates Jorge Godoy 00:58
simple? query Jan Verheyden 11:36
Re: mail alert Jasen Betts 12:08
Re: mail alert Jasen Betts 12:16
Re: simple? query Relyea, Mike 20:46
Re: mail alert Alvaro Herrera 21:54
Re: mail alert Tim Landscheidt 22:24
Re: mail alert Alvaro Herrera 22:36
Re: mail alert Adrian Klaver 23:30

Aug. 14, 2009

Thread Author Time
Re: simple? query Jasen Betts 08:58
Field or record level encryption / decryption Hengky Lie 09:20
Re: simple? query Relyea, Mike 12:58
Re: Field or record level encryption / decryption Joshua Tolley 13:24
Re: simple? query Relyea, Mike 14:21
Re: simple? query Tim Landscheidt 14:53
Re: mail alert Christopher Browne 15:18
Re: Field or record level encryption / decryption Christopher Browne 15:21
Re: Field or record level encryption / decryption Hengky Lie 16:07
Re: Field or record level encryption / decryption Joshua Tolley 22:28

Aug. 17, 2009

Thread Author Time
Multiple simultaneous queries on single connection Yeb Havinga 12:49

Aug. 18, 2009

Thread Author Time
FW: simple? query Jan Verheyden 07:04
operator contains in older Pgsql W. Kinastowski 07:47
Re: operator contains in older Pgsql Jasen Betts 09:44
Re: operator contains in older Pgsql W. Kinastowski 10:16
Re: operator contains in older Pgsql Jasen Betts 11:18
SQL Query Performance - what gives? 📎 Karl Denninger 19:45
Re: SQL Query Performance - what gives? Kevin Grittner 20:23
Re: SQL Query Performance - what gives? 📎 Karl Denninger 20:58
Updating one table with data from another drew 21:02
Re: SQL Query Performance - what gives? Kevin Grittner 21:59
Re: SQL Query Performance - what gives? 📎 Karl Denninger 23:03
Re: FW: simple? query Tim Landscheidt 23:39

Aug. 19, 2009

Thread Author Time
Re: Multiple simultaneous queries on single connection Craig Ringer 01:35
Re: [SQL] SQL Query Performance - what gives? Tom Lane 02:02
Re: [SQL] SQL Query Performance - what gives? 📎 Karl Denninger 02:47
Re: [SQL] SQL Query Performance - what gives? Pierre Frédéric Caillaud 06:27
Ask To Optimize Looping Otniel Michael 09:22
Ask About SQL Otniel Michael 10:17
Re: SQL Query Performance - what gives? Ivan Voras 10:19
Re: Ask About SQL A. Kretschmer 10:46
Re: Ask About SQL Joshua Tolley 14:00
Re: Multiple simultaneous queries on single connection Yeb Havinga 15:15
Re: Ask To Optimize Looping Marc Mamin 15:46
Call Procedure From Trigger Function Doug Pisarek 21:53

Aug. 20, 2009

Thread Author Time
Re: Call Procedure From Trigger Function Scott Marlowe 04:01
Re: Call Procedure From Trigger Function ramasubramanian 04:29
Re: Updating one table with data from another Jasen Betts 10:51
Advice returning data as an array George Woodring 12:07
using case to select 'which version to use' Gerardo Herzig 15:17
Re: using case to select 'which version to use' Rodrigo E. De León Plicet 16:33
Rewrite without correlated subqueries bricklen 20:32
Re: Rewrite without correlated subqueries 📎 Mark Fenbers 20:40
Re: Rewrite without correlated subqueries bricklen 21:16
Re: Rewrite without correlated subqueries Scott Marlowe 21:59
Re: Rewrite without correlated subqueries bricklen 22:03

Aug. 21, 2009

Thread Author Time
Rewrite multiple joins... tripplowe 03:17
Re: Rewrite multiple joins... Rob Sargent 15:15
Re: using case to select 'which version to use' Gerardo Herzig 18:13
multiple substitution in a single replace call? Gerardo Herzig 20:16

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

Browse Archives

Prev | Next