pgsql-sql since 2010-02-17 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

Feb. 17, 2010

Thread Author Time
very frustrating feature-bug silly sad 07:20
Re: very frustrating feature-bug Jasen Betts 10:51
Re: very frustrating feature-bug silly sad 11:34
Re: very frustrating feature-bug Pavel Stehule 11:37
Referencing external table in update/insert triggers Amitabh Kant 15:18
Re: very frustrating feature-bug Tom Lane 15:27
Re: very frustrating feature-bug Achilleas Mantzios 15:33

Feb. 18, 2010

Thread Author Time
Re: Referencing external table in update/insert triggers Richard Huxton 09:23
Re: Referencing external table in update/insert triggers Amitabh Kant 09:33
Problem with batch insert zkn 12:53
Re: Problem with batch insert Tom Lane 15:32
Re: Problem with batch insert zkn 16:05

Feb. 19, 2010

Thread Author Time
sintax error iuri de araujo sampaio 07:52
Unable to get UPDATE ... FROM syntax correct Gordon Ross 09:25
Re: Unable to get UPDATE ... FROM syntax correct zkn 10:28
Re: Unable to get UPDATE ... FROM syntax correct Gordon Ross 10:32
Re: Unable to get UPDATE ... FROM syntax correct Richard Huxton 10:36
Re: sintax error Richard Huxton 10:56
Re: Unable to get UPDATE ... FROM syntax correct Gordon Ross 10:58
Re: Unable to get UPDATE ... FROM syntax correct Richard Huxton 11:33
Re: sintax error Tom Lane 14:28

Feb. 21, 2010

Thread Author Time
Join Advice and Assistance Gary Chambers 23:25

Feb. 22, 2010

Thread Author Time
Re: Join Advice and Assistance Rob Sargent 05:10
Re: Join Advice and Assistance Gary Chambers 15:51
Re: Join Advice and Assistance Rob Sargent 17:05
Re: Join Advice and Assistance Stephen Belcher 17:15
Re: Join Advice and Assistance Gary Chambers 22:43

Feb. 24, 2010

Thread Author Time
join with an array Louis-David Mitterrand 12:40
Re: join with an array A. Kretschmer 13:09
Re: join with an array Louis-David Mitterrand 13:34
Microsoft Sync Framework Ricardo S. Carvalho 13:42
Re: join with an array Achilleas Mantzios 14:39

Feb. 25, 2010

Thread Author Time
Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule Aron 15:19
Re: Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule Tom Lane 15:28

Feb. 26, 2010

Thread Author Time
what exactly is a query structure? silly sad 06:50
Re: what exactly is a query structure? A. Kretschmer 07:19
Re: what exactly is a query structure? silly sad 09:42
Re: what exactly is a query structure? silly sad 09:44
Re: what exactly is a query structure? A. Kretschmer 09:53
Re: what exactly is a query structure? Tom Lane 15:11

Feb. 27, 2010

Thread Author Time
Date comparison, user defined operators and magic Petru Ghita 03:08
Re: Date comparison, user defined operators and magic Tom Lane 03:32
Issue with insert Michael Gould 17:14
Re: Issue with insert Scott Marlowe 17:50
Re: Issue with insert Michael Gould 20:25
Re: Issue with insert Tom Lane 20:58
Re: Issue with insert Michael Gould 21:02

March 1, 2010

Thread Author Time
kind of RULE on SELECT depending on existence of a WHERE condition rawi 10:07
Re: kind of RULE on SELECT depending on existence of a WHERE condition Richard Huxton 10:34
Re: kind of RULE on SELECT depending on existence of a WHERE condition rawi 12:16
placement of stored procedures and contrib modules Michael Gould 13:25
Re: kind of RULE on SELECT depending on existence of a WHERE condition Richard Huxton 13:38
Re: Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule Aron 16:30
Create functions using a function Gianvito Pio 21:50
Re: Create functions using a function Petru Ghita 22:38

March 2, 2010

Thread Author Time
Trigger on select :-( 📎 Ray Madigan 02:10
Re: kind of RULE on SELECT depending on existence of a WHERE condition rawi 09:43
Re: kind of RULE on SELECT depending on existence of a WHERE condition Craig Ringer 12:07
determine the curval() of a view John 15:35

March 3, 2010

Thread Author Time
check constraint on multiple tables? Louis-David Mitterrand 15:02
Re: check constraint on multiple tables? Richard Broersma 15:14
Re: check constraint on multiple tables? Louis-David Mitterrand 15:19
Re: check constraint on multiple tables? Richard Broersma 15:29
Re: check constraint on multiple tables? Louis-David Mitterrand 15:38
Re: check constraint on multiple tables? Richard Broersma 15:57
Re: check constraint on multiple tables? Little, Douglas 16:03
Re: check constraint on multiple tables? Oliveiros 16:05
Re: check constraint on multiple tables? Louis-David Mitterrand 16:06
Re: check constraint on multiple tables? Little, Douglas 16:13
Re: check constraint on multiple tables? Louis-David Mitterrand 16:17
Re: check constraint on multiple tables? Louis-David Mitterrand 16:21
Re: check constraint on multiple tables? Little, Douglas 16:29
Re: check constraint on multiple tables? Louis-David Mitterrand 16:38
Triggers on system tables Gianvito Pio 17:29
Re: Triggers on system tables Andreas Kretschmer 17:50

March 4, 2010

Thread Author Time
Deleting rows from a table not contained in another table Florian Weimer 10:51
an aggregate to return max() - 1 value? Louis-David Mitterrand 20:09
Re: an aggregate to return max() - 1 value? Gerardo Herzig 20:14
Re: an aggregate to return max() - 1 value? Rob Sargent 20:20
Re: an aggregate to return max() - 1 value? Greg Stark 20:53

March 5, 2010

Thread Author Time
Re: an aggregate to return max() - 1 value? Pavel Stehule 06:33
PostgreSQL Active-Active Configuration Dave Clements 07:25
Re: PostgreSQL Active-Active Configuration Iñigo Martinez Lasala 08:20
Re: PostgreSQL Active-Active Configuration Devrim GÜNDÜZ 08:25
client_timezone to server_timezone and reverse silly sad 11:45
Re: [SQL] PostgreSQL Active-Active Configuration Plugge, Joe R. 13:58

March 6, 2010

Thread Author Time
Does IMMUTABLE property propagate? Petru Ghita 02:44
Re: Create functions using a function Jasen Betts 07:55
Re: Does IMMUTABLE property propagate? Jasen Betts 08:02
Check type compatibility Gianvito Pio 11:04
Re: Check type compatibility Nilesh Govindarajan 11:22
Re: Check type compatibility Little, Douglas 13:21
Re: an aggregate to return max() - 1 value? Louis-David Mitterrand 13:31
Re: Does IMMUTABLE property propagate? Greg Stark 14:45
Assigning NEW. anomoly Little, Douglas 16:16
Re: Does IMMUTABLE property propagate? Petru Ghita 16:16
Drop all constraints Gianvito Pio 16:34
Re: Drop all constraints Andreas Kretschmer 17:17
Re: Does IMMUTABLE property propagate? Tom Lane 21:31

March 8, 2010

Thread Author Time
list of all months query 12:25

March 9, 2010

Thread Author Time
Re: Help : insert a bytea data into new table Ben Morrow 03:46
Re: Help : insert a bytea data into new table dennis 07:45
Re: Help : insert a bytea data into new table Ben Morrow 11:14
Odd query behavior Dan McFadyen 14:08

March 10, 2010

Thread Author Time
Re: Help : insert a bytea data into new table dennis 02:43
Clarification With Money data type Navanethan Muthusamy 07:19
Remote monitoring of Postgres w/minimal grants Bryce Nesbitt 07:26
Re: Help : insert a bytea data into new table Ben Morrow 15:25

March 11, 2010

Thread Author Time
Re: Help : insert a bytea data into new table dennis 04:09
Re: Clarification With Money data type Jasen Betts 08:49
Re: Help : insert a bytea data into new table Ben Morrow 11:46
Selecting names of indexes that are not dependent on constraints. Dmitriy Igrishin 15:15
Re: Selecting names of indexes that are not dependent on constraints. Dmitriy Igrishin 15:20
Re: Selecting names of indexes that are not dependent on constraints. Tom Lane 15:34
Re: Help : insert a bytea data into new table dennis 16:07
Re: Trigger on select :-( Garrett Murphy 16:33
Re: Help : insert a bytea data into new table Ben Morrow 18:00
Re: Remote monitoring of Postgres w/minimal grants Tony Wasson 22:20

March 12, 2010

Thread Author Time
Re: Trigger on select :-( Jaime Casanova 06:56
Re: Clarification With Money data type 📎 Ireneusz Pluta 08:10
Odd query behavior Dan McFadyen 15:41
Re: Odd query behavior Rob Sargent 16:06
Re: Odd query behavior Tom Lane 16:29

March 13, 2010

Thread Author Time
Private functions Gianvito Pio 17:57
Re: Private functions Pavel Stehule 18:00

March 14, 2010

Thread Author Time
Re: Private functions Jasen Betts 03:21
Linked list with CTE Mark Lubratt 23:51

March 15, 2010

Thread Author Time
Re: Private functions silly sad 06:25
Re: Odd query behavior silly sad 11:27
Re: Odd query behavior Tom Lane 15:03
Re: Odd query behavior Dan McFadyen 17:01
Re: Odd query behavior Tom Lane 17:14
Please delete my email Eduardo Palafox 17:18
Remove my e-mail Daniel Guedes 17:24
Re: Please delete my email Adrian Klaver 17:29
Re: Remove my e-mail Adrian Klaver 17:29
I, nead to capture the IP number from the PC how is running the script ... John Dizaro 19:18
Re: I, nead to capture the IP number from the PC how is running the script ... Niklas Johansson 19:41
Re: I, nead to capture the IP number from the PC how is running the script ... Ing. Marcos Ortiz Valmaseda 20:19
Re: I, nead to capture the IP number from the PC how is running the script ... Gerardo Herzig 20:40
Re: list of all months Garrett Murphy 21:16
Re: list of all months Petru Ghita 21:41
Re: list of all months Dawid Kuroczko 22:25
installing uuid generators Rob Sargent 23:58

March 16, 2010

Thread Author Time
Re: list of all months silly sad 06:12
Re: I, nead to capture the IP number from the PC how is running the script ... silly sad 06:28
pgAgent stats Marcin Krawczyk 07:40
Re: list of all months Jasen Betts 09:02
Re: installing uuid generators Richard Huxton 09:20
DROP RULE ... CASCADE Dmitriy Igrishin 09:39
Rename Index - Deadlock Thomas Kenner 09:45
SQL code beautifier for PostgreSQL. Dmitriy Igrishin 09:59
Re: DROP RULE ... CASCADE Tom Lane 14:24
Re: Rename Index - Deadlock Tom Lane 16:16
Re: Rename Index - Deadlock Scott Marlowe 16:39
Re: installing uuid generators Rob Sargent 18:08
Avoiding cycles in a directed graph Tony Cebzanov 19:45
Re: installing uuid generators Richard Huxton 20:11
Re: Avoiding cycles in a directed graph Richard Huxton 20:17
Re: installing uuid generators Tom Lane 20:26
Re: Avoiding cycles in a directed graph Tom Lane 20:34
Re: Avoiding cycles in a directed graph Tony Cebzanov 20:49
Re: Avoiding cycles in a directed graph Tom Lane 21:09
Re: Avoiding cycles in a directed graph Richard Huxton 22:14
Re: Avoiding cycles in a directed graph Tom Lane 22:22
Re: installing uuid generators Rob Sargent 23:14
Re: installing uuid generators Tom Lane 23:29
Re: installing uuid generators Jorge Godoy 23:42

March 17, 2010

Thread Author Time
Postgresql format for ISO8601 Arnab Ghosh 06:59
Re: Postgresql format for ISO8601 A. Kretschmer 07:13
select points of polygons Andreas Gaab 09:08
Re: pgAgent stats Guillaume Lelarge 12:02
Re: pgAgent stats Marcin Krawczyk 12:15
Re: pgAgent stats Dave Page 12:19
Re: pgAgent stats Marcin Krawczyk 12:24
Postgresql format for ISO8601 Arnab Ghosh 12:25
Re: pgAgent stats Dave Page 12:28
inheritance Zdravko Balorda 12:33
Re: pgAgent stats Marcin Krawczyk 12:40
Re: pgAgent stats Marcin Krawczyk 12:42
Re: pgAgent stats Dave Page 12:43
Re: Postgresql format for ISO8601 Tom Lane 14:10
8.4 versus 8.2 against nonexistent column "name" ... James Robinson 14:16
Re: select points of polygons Tom Lane 14:21
Re: 8.4 versus 8.2 against nonexistent column "name" ... Osvaldo Kussama 14:48
MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date Ignacio Balcarce 14:52
strange issue with UUID data types Michael Gould 16:29
Re: strange issue with UUID data types Rob Sargent 16:42
Re: Avoiding cycles in a directed graph Tony Cebzanov 18:36
Re: strange issue with UUID data types Michael Gould 19:18

March 18, 2010

Thread Author Time
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date silly sad 10:33
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date silly sad 10:37
Simple aggregate query brain fart 📎 Mark Fenbers 15:06
Re: Simple aggregate query brain fart Plugge, Joe R. 15:10
Re: Simple aggregate query brain fart Tom Lane 15:11
Re: Simple aggregate query brain fart 📎 Mark Fenbers 15:15
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date Justin Graf 17:02
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date Ignacio Balcarce 17:53
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date Justin Graf 18:48
Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date Justin Graf 18:55

Browse Archives

Prev | Next