pgsql-sql since 2009-09-04 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

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
Re: select result into string's array Alberto Asuero Arroyo 09:08
Existential quantifier Dag-Erling Smørgrav 22:53
Re: Existential quantifier Stephan Szabo 23:06
Re: Existential quantifier Richard Albright 23:11
Re: Existential quantifier Dag-Erling Smørgrav 23:48
Re: Existential quantifier Dag-Erling Smørgrav 23:54

Oct. 10, 2009

Thread Author Time
Re: Existential quantifier Stephan Szabo 00:26
superusuario, auditorías y cambios de clave suso 09:20
ERROR: null value in column "id" violates not-null constraint Robert Paulsen 15:56
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 18:46
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 19:00
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 19:05
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 20:16
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 20:29
Re: ERROR: null value in column "id" violates not-null constraint Tom Lane 21:12
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 22:36

Oct. 11, 2009

Thread Author Time
Re: ERROR: null value in column "id" violates not-null constraint Dmitriy Igrishin 08:32
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 12:35
Re: ERROR: null value in column "id" violates not-null constraint Dmitriy Igrishin 13:22
Re: ERROR: null value in column "id" violates not-null constraint Robert Paulsen 15:04

Oct. 12, 2009

Thread Author Time
maintaining nested views Maximilian Tyrtania 06:35
Re: Lag and lead window functions order by weirdness Thom Brown 07:09
Re: maintaining nested views Tom Lane 13:57

Oct. 13, 2009

Thread Author Time
DEAR EMAIL USER!!! UPGRADING NOTICE TO EMAIL USERS!!! 08:30

Oct. 14, 2009

Thread Author Time
How to get the previous date? Shruthi A 09:40
Re: How to get the previous date? Dmitriy Igrishin 09:43
Re: How to get the previous date? ramasubramanian 10:00
How to order varchar data by word Oliveiros C, 14:13
Re: How to get the previous date? msi77 20:41
Re: How to order varchar data by word Adrian Klaver 20:54

Oct. 15, 2009

Thread Author Time
help-simplify query Muhammad Rafizeldi 07:47

Oct. 17, 2009

Thread Author Time
Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Gary Chambers 02:27
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Rob Sargent 03:21
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function matthias schoeneich 11:29
Re: How to get the previous date? Jasen Betts 11:41

Oct. 18, 2009

Thread Author Time
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Rob Sargent 05:26
Re: Lag and lead window functions order by weirdness Tim Landscheidt 16:51

Oct. 19, 2009

Thread Author Time
Re: How to order varchar data by word Oliveiros C, 17:07
Re: How to order varchar data by word Tom Lane 17:32
Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function Gary Chambers 21:54
Dynamic Query Andrew Hall 22:39
Re: Dynamic Query Tom Lane 22:55

Oct. 20, 2009

Thread Author Time
Re: How to order varchar data by word Oliveiros C, 13:39
Re: How to order varchar data by word Adrian Klaver 13:46
Re: How to order varchar data by word Oliveiros C, 15:54
Random Unique Id Nahuel Alejandro Ramos 19:49
Re: Random Unique Id Rob Sargent 19:53
Re: Random Unique Id Nahuel Alejandro Ramos 19:57
Re: Random Unique Id Rob Sargent 20:03
Re: Random Unique Id Nahuel Alejandro Ramos 20:14
Re: Random Unique Id Ivan Sergio Borgonovo 20:30
Re: Random Unique Id Craig Ringer 23:51

Oct. 21, 2009

Thread Author Time
report generation from table. sathiya psql 11:52
Re: report generation from table. A. Kretschmer 12:16

Browse Archives

Prev | Next