pgsql-sql - September 2009

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 9 10 11 13 14 15 16 17 18 19 21 22 23 24 25 26 28 29

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

Browse Archives

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