pgsql-sql since 2010-03-15 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

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
Re: SQL syntax rowcount value as an extra column in the result set A. Kretschmer 06:23
Re: Help me with this multi-table query A. Kretschmer 06:45
Re: SQL syntax rowcount value as an extra column in the result set Jayadevan M 06:56
Re: SQL syntax rowcount value as an extra column in the result set Thomas Kellerer 07:14
Re: Plpgsql: Iterating through a string of parameters Jasen Betts 08:49
Re: Week to date function Ireneusz Pluta 10:48
Re: Week to date function Sergey Konoplev 11:02
Re: Week to date function Ireneusz Pluta 11:47

March 27, 2010

Thread Author Time
Re: Week to date function Jorge Godoy 18:08
Re: Week to date function Ireneusz Pluta 20:22
Re: Week to date function Hiltibidal, Rob 21:31

March 28, 2010

Thread Author Time
Re: Week to date function Jorge Godoy 01:51

March 29, 2010

Thread Author Time
Re: SQL syntax rowcount value as an extra column in the result set Snyder, James 16:25
SQL Developer accessing PostgreSQL Snyder, James 16:33
Re: SQL Developer accessing PostgreSQL Hiltibidal, Rob 17:22
How do I search a two dimensional array? Joseph S 22:17

March 30, 2010

Thread Author Time
Re: SQL Developer accessing PostgreSQL silly sad 04:48
Re: SQL syntax rowcount value as an extra column in the result set Thomas Kellerer 08:03

March 31, 2010

Thread Author Time
Re: SQL Developer accessing PostgreSQL 📎 Jose Alarcon 07:01
Re: SQL Developer accessing PostgreSQL Thomas Kellerer 08:12
Re: Week to date function Jasen Betts 11:44
Re: Capacity planning. Bruce Momjian 14:47

April 1, 2010

Thread Author Time
Re: Capacity planning. Brad Nicholson 13:12

April 3, 2010

Thread Author Time
count function alternative in postgres junaidmalik14 12:58

April 4, 2010

Thread Author Time
INSERT INTO...RETURNING vs SELECT Cliff Wells 22:12

April 5, 2010

Thread Author Time
INSERT INTO...RETURNING vs SELECT Cliff Wells 04:48
Re: INSERT INTO...RETURNING vs SELECT Andreas Kretschmer 07:10
Re: INSERT INTO...RETURNING vs SELECT Cliff Wells 15:40

April 6, 2010

Thread Author Time
Table Design for Hierarchical Data Lee Hachadoorian 17:33
Re: count function alternative in postgres Thomas Kellerer 17:39
Re: count function alternative in postgres Ben Morrow 18:47
Re: Table Design for Hierarchical Data Michael Glaesemann 22:04
Re: Table Design for Hierarchical Data Richard Broersma 22:48

April 7, 2010

Thread Author Time
Re: Table Design for Hierarchical Data Steve Crawford 00:23
Re: Table Design for Hierarchical Data silly sad 05:41
Re: Table Design for Hierarchical Data silly sad 05:43
Re: Table Design for Hierarchical Data Scott Marlowe 06:17
Re: Table Design for Hierarchical Data Achilleas Mantzios 07:00
Re: Table Design for Hierarchical Data silly sad 07:53
Re: Table Design for Hierarchical Data Yeb Havinga 08:06
Re: Table Design for Hierarchical Data Sergey Konoplev 08:26
Re: Table Design for Hierarchical Data Achilleas Mantzios 08:28
Re: Table Design for Hierarchical Data Achilleas Mantzios 08:34
Re: Table Design for Hierarchical Data Achilleas Mantzios 08:39
Re: Table Design for Hierarchical Data Lee Hachadoorian 18:27
Re: Table Design for Hierarchical Data Yeb Havinga 20:33

April 8, 2010

Thread Author Time
Re: Table Design for Hierarchical Data Achilleas Mantzios 06:56
Re: Table Design for Hierarchical Data Yeb Havinga 07:40
Problem with function returning a result set Thomas Kellerer 08:54
Re: Problem with function returning a result set Tom Lane 08:59
Re: Problem with function returning a result set Pavel Stehule 09:01
Re: Problem with function returning a result set Thomas Kellerer 09:29
Re: Table Design for Hierarchical Data Rob Sargent 14:59
Howto get a group_number like row_number for groups Andreas 19:51

April 9, 2010

Thread Author Time
Re: Howto get a group_number like row_number for groups Jaime Casanova 03:41
Cascading sum in tree with CTE? Svenne Krap 07:17
Re: Cascading sum in tree with CTE? silly sad 09:12
Re: Cascading sum in tree with CTE? Harald Fuchs 10:51
understanding select into John 17:18
Re: understanding select into Plugge, Joe R. 17:31
Re: understanding select into Pavel Stehule 17:32
Re: understanding select into John 17:53

April 12, 2010

Thread Author Time
Re: Table Design for Hierarchical Data Achilleas Mantzios 08:14
Re: Howto get a group_number like row_number for groups msi77 14:19
Re: Table Design for Hierarchical Data Rob Sargent 14:57
Re: Table Design for Hierarchical Data Leif Biberg Kristensen 15:30
Re: Table Design for Hierarchical Data Yeb Havinga 15:37
Re: Table Design for Hierarchical Data Leif Biberg Kristensen 15:56

April 13, 2010

Thread Author Time
Getting the initdb parameter values Satish Burnwal (sburnwal) 11:50
Re: [ADMIN] Getting the initdb parameter values Iñigo Martinez Lasala 12:56
Re: [ADMIN] Getting the initdb parameter values Satish Burnwal (sburnwal) 13:01
Re: Getting the initdb parameter values Kevin Grittner 13:54
Re: Getting the initdb parameter values Greg Smith 17:13
Re: [ADMIN] Getting the initdb parameter values Rob Sargent 17:57
Re: Getting the initdb parameter values Julio Leyva 18:01

April 14, 2010

Thread Author Time
How to max() make null as biggest value? Feixiong Li 04:33
Problem with insert related to different schemas Gonzalo Aguilar Delgado 08:23
Using CASE in plpgsql causes 'ERROR: cache lookup failed' Mario Splivalo 09:48
graphing time series data Louis-David Mitterrand 14:54
Re: graphing time series data Richard Broersma 15:46

Browse Archives

Prev | Next