pgsql-sql - March 2010

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 6 8 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31

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
Emacs sql-postgres (please, sorry for question not about PostgreSQL). Dmitriy Igrishin 21:43
Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL). Hiltibidal, Rob 22:18
Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL). Tom Lane 22:59

March 19, 2010

Thread Author Time
Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL). Pavel Stehule 06:30
Re: Emacs sql-postgres (please, sorry for question not about PostgreSQL). Pavel Stehule 06:32

March 20, 2010

Thread Author Time
Re: Linked list with CTE Gurjeet Singh 03:34
Stefanie Diedrich mahmoud ewiwi 09:11

March 22, 2010

Thread Author Time
ALTER TYPE my_enum AS ENUM ADD ('label10') Andreas Gaab 14:33
Re: ALTER TYPE my_enum AS ENUM ADD ('label10') A. Kretschmer 15:05

March 23, 2010

Thread Author Time
string functions and operators Neil Stlyz 01:20
Re: string functions and operators Petru Ghita 01:50
Re: string functions and operators Petru Ghita 02:08
Re: string functions and operators Neil Stlyz 02:16
Re: string functions and operators Petru Ghita 03:42
Re: string functions and operators John R Pierce 03:49
Re: string functions and operators Petru Ghita 03:52
Re: string functions and operators Andreas Gaab 08:13
Re: ALTER TYPE my_enum AS ENUM ADD ('label10') A. Kretschmer 08:31
Re: string functions and operators Little, Douglas 14:30
Help me with this multi-table query Nilesh Govindarajan 14:37

March 24, 2010

Thread Author Time
window function to sort times series data? Louis-David Mitterrand 14:08
Re: window function to sort times series data? A. Kretschmer 14:29
Re: window function to sort times series data? Louis-David Mitterrand 14:36
Re: window function to sort times series data? A. Kretschmer 15:04
Re: window function to sort times series data? Andreas Kretschmer 16:29
Re: window function to sort times series data? Louis-David Mitterrand 16:49
Re: window function to sort times series data? John Gage 18:38
Help with reg_exp John Gage 18:58
Re: window function to sort times series data? Josh Kupershmidt 19:13
Dollar quoted strings John Gage 20:38

March 25, 2010

Thread Author Time
Re: Dollar quoted strings Robert Manning 03:20
Re: Does IMMUTABLE property propagate? Louis-David Mitterrand 06:16
Re: Does IMMUTABLE property propagate? Pavel Stehule 07:27
Re: Does IMMUTABLE property propagate? Louis-David Mitterrand 07:54
Week to date function 📎 Ireneusz Pluta 09:25
Re: Week to date function Sergey Konoplev 09:44
Capacity planning. David Harel 14:02
Re: Does IMMUTABLE property propagate? Tom Lane 14:35
Plpgsql: Iterating through a string of parameters Leif Biberg Kristensen 15:16
Re: Plpgsql: Iterating through a string of parameters Leif Biberg Kristensen 16:00
Re: Does IMMUTABLE property propagate? Greg Stark 16:05
Re: Does IMMUTABLE property propagate? Pavel Stehule 16:26
Re: Does IMMUTABLE property propagate? Tom Lane 16:55
SQL syntax rowcount value as an extra column in the result set Snyder, James 21:33
Re: SQL syntax rowcount value as an extra column in the result set Thomas Kellerer 21:55

March 26, 2010

Thread Author Time
Re: SQL syntax rowcount value as an extra column in the result set Jayadevan M 03:35
Re: SQL syntax rowcount value as an extra column in the result set Jayadevan M 03:42

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31