pgsql-sql since 2011-08-25 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

Aug. 25, 2011

Thread Author Time
new table with a select ppdcc 09:35
new table with a select ppdcc 09:44
Re: new table with a select 📎 Julien Cigar 09:48
Re: new table with a select Florian Weimer 10:44
Add one column to another gvim 14:21
Re: Add one column to another Tony Capobianco 14:30
Re: Add one column to another Oliveiros d'Azevedo Cristina 14:52
Re: Add one column to another David Johnston 14:53
Re: Add one column to another Tim Landscheidt 17:50
Re: Add one column to another Scott Marlowe 17:54
Re: Add one column to another vipul shah 19:46
st_offsetcurve ppdcc 20:17
Need a little help with geometric query lxnf98mm 22:56
Re: st_offsetcurve Brent Dombrowski 23:35

Aug. 26, 2011

Thread Author Time
Re: Need a little help with geometric query Samuel Gendler 00:08
Re: (pgsql8.4) DATA Corruption Craig Ringer 03:51
Re: new table with a select MIkhail Puzanov 07:06

Aug. 28, 2011

Thread Author Time
Re: [SQL] parsing audit table Jan Eskilsson 10:00

Aug. 30, 2011

Thread Author Time
where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 14:51
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? 📎 Julien Cigar 15:01
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane 15:24
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 15:48
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane 15:53
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 15:57

Aug. 31, 2011

Thread Author Time
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emre Hasegeli 07:16
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Jasen Betts 10:17
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu 12:54
ERROR: cannot subscript type text because it is not an array lxnf98mm 13:26
Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Pavel Stehule 16:16
function based index problem Viktor Bojović 21:27
Re: function based index problem Kevin Grittner 21:53
Re: [SQL] function based index problem David Johnston 22:09
Re: function based index problem Viktor Bojović 22:17
Re: function based index problem Viktor Bojović 22:21

Sept. 1, 2011

Thread Author Time
Want some basic compare of data type on PostgreSQL and MySQL bhavesh1385 05:15
Re: Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe 09:16
Re: Want some basic compare of data type on PostgreSQL and MySQL Samuel Gendler 09:38
Re: Want some basic compare of data type on PostgreSQL and MySQL Jasen Betts 11:22
Re: Want some basic compare of data type on PostgreSQL and MySQL Leif Biberg Kristensen 13:32
Re: Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe 13:45
Schema partitioning Charlie 18:13

Sept. 2, 2011

Thread Author Time
Re: Schema partitioning David Johnston 13:20
Re: Schema partitioning Little, Douglas 13:22

Sept. 7, 2011

Thread Author Time
How can I inherit constraints? Andreas 01:04

Sept. 9, 2011

Thread Author Time
My Trigger is not working :( Waqar Azeem 12:27
Re: how can I get the length of columns of a table by system tables/views shuaixf 12:53
Re: My Trigger is not working :( pasman pasmański 13:23
Re: My Trigger is not working :( Waqar Azeem 13:31

Sept. 10, 2011

Thread Author Time
Re: Re: how can I get the length of columns of a table by system tables/views msi77 05:51
Dynamic sql Gabriel Filipiak 06:45
Re: Dynamic sql Jasen Betts 09:18
FW: Hi Mandana Mokhtary 21:22
FW: Hi Mandana Mokhtary 21:22
Re: FW: Hi Adrian Klaver 22:04

Sept. 12, 2011

Thread Author Time
Re: FW: Hi Craig Ringer 01:31
Use select and update together Boris 10:36

Sept. 13, 2011

Thread Author Time
Re: Use select and update together pasman pasmański 05:50
Re: Use select and update together Samuel Gendler 06:45
Partition over a sliding date window Guillaume Roger 11:25
Window function sort order help Dianna Harter 18:04
Re: Window function sort order help nicoletta maia 20:53

Sept. 14, 2011

Thread Author Time
Re: Window function sort order help Nicoletta Maia 08:30
Re: Window function sort order help Thomas Kellerer 09:02
Re: Window function sort order help Dianna Harter 16:54
Re: Window function sort order help Nicoletta Maia 17:24

Sept. 15, 2011

Thread Author Time
Clever way to check overlapping time intervals ? Andreas 23:40

Sept. 16, 2011

Thread Author Time
Re: Clever way to check overlapping time intervals ? Andreas Kretschmer 00:15
Re: Clever way to check overlapping time intervals ? pasman pasmański 09:17
Re: Clever way to check overlapping time intervals ? Frank Bax 11:15
Re: Window function sort order help Tim Landscheidt 23:55

Sept. 17, 2011

Thread Author Time
Passing function parameters to regexp_replace Leif Biberg Kristensen 11:21
Re: Passing function parameters to regexp_replace Leif Biberg Kristensen 11:31
Sorting of data from two tables R. Smith 13:32
Re: Sorting of data from two tables David Johnston 13:56
insert or update within transaction Andreas 14:52
Re: Use select and update together Andreas 14:56
Re: insert or update within transaction Josh Kupershmidt 15:49
Re: Use select and update together Guillaume Lelarge 15:51
Re: Use select and update together Tom Lane 16:16
Re: Passing function parameters to regexp_replace Tim Landscheidt 17:07
Re: Passing function parameters to regexp_replace Leif Biberg Kristensen 17:27
select xpath ... boris 17:48
Re: Passing function parameters to regexp_replace Tim Landscheidt 18:34

Sept. 19, 2011

Thread Author Time
Re: select xpath ... Rob Sargent 14:49
Re: select xpath ... boris 15:49
Re: Window function sort order help Dianna Harter 21:31

Sept. 20, 2011

Thread Author Time
Combining several CTEs with a recursive CTE Thomas Kellerer 09:58
Re: Combining several CTEs with a recursive CTE David Johnston 14:15
Re: Combining several CTEs with a recursive CTE Thomas Kellerer 14:54

Sept. 21, 2011

Thread Author Time
handling duplicate row exception Amar Dhole 05:54
Re: handling duplicate row exception Filip Rembiałkowski 15:07
Re: Trigger Procedure Error: NEW used in query that is not in a rule jablonov 15:32
Re: select xpath ... Brian Sherwood 16:27
ambiguous local variable name in 9.0 proc Samuel Gendler 23:35
Re: ambiguous local variable name in 9.0 proc David Johnston 23:49
Re: ambiguous local variable name in 9.0 proc Samuel Gendler 23:55

Sept. 22, 2011

Thread Author Time
Re: ambiguous local variable name in 9.0 proc Tom Lane 00:00
a spatial table's bounding box Asli Akarsakarya 06:04
Re: handling duplicate row exception Amar Dhole 06:11
help with xpath namespace Brian Sherwood 15:03

Sept. 23, 2011

Thread Author Time
using the aggregate function max() John Fabiani 02:49
Re: using the aggregate function max() David Johnston 03:14
Re: using the aggregate function max() John Fabiani 04:40
use of savepoint in containter managed transaction Amar Dhole 06:32
Re: using the aggregate function max() Thomas Kellerer 06:37
Re: help with xpath namespace Filip Rembiałkowski 16:14
Re: a spatial table's bounding box Filip Rembiałkowski 19:18

Sept. 24, 2011

Thread Author Time
Howto build a funtion that selects an id or inserts a value Andreas 00:06
Better way to check more than 1 value NOT IN (...) Andreas 09:38
Re: Better way to check more than 1 value NOT IN (...) pasman pasmański 11:54

Sept. 25, 2011

Thread Author Time
Re: Sorting of data from two tables R. Smith 16:37
Re: Sorting of data from two tables David Johnston 18:44

Sept. 26, 2011

Thread Author Time
Re: help with xpath namespace Brian Sherwood 13:56

Sept. 27, 2011

Thread Author Time
Re: handling duplicate row exception Filip Rembiałkowski 00:57
how to calculate differences of timestamps? Andreas 01:31
Re: how to calculate differences of timestamps? Tim Landscheidt 02:42
Re: how to calculate differences of timestamps? Steve Crawford 16:08

Sept. 29, 2011

Thread Author Time
Edit multiple rows concurrent save Péter Szabó 21:58
Edit multiple rows concurrent save Péter Szabó 22:07

Oct. 4, 2011

Thread Author Time
Re: a spatial table's bounding box Asli Akarsakarya 18:22

Oct. 6, 2011

Thread Author Time
plpgsql function executed multiple times for each return value Steve Northamer 17:59

Oct. 8, 2011

Thread Author Time
Re: Edit multiple rows concurrent save Jasen Betts 09:19
Re: plpgsql function executed multiple times for each return value David Johnston 15:50
Re: plpgsql function executed multiple times for each return value Tom Lane 16:32

Oct. 9, 2011

Thread Author Time
[GENERAL] Creating rule for sliding data F. BROUARD / SQLpro 10:22
Re: [GENERAL] Creating rule for sliding data F. BROUARD / SQLpro 16:50
Re: [GENERAL] Creating rule for sliding data Guillaume Lelarge 17:07
Re: [GENERAL] Creating rule for sliding data Guillaume Lelarge 20:25

Oct. 10, 2011

Thread Author Time
Re: HAKAN 18:31

Oct. 11, 2011

Thread Author Time
Re: Extract week from date, start with sunday skdangi 16:19

Oct. 12, 2011

Thread Author Time
[No subject] HAKAN 00:15
[No subject] Theodore Petrosky 05:37

Oct. 14, 2011

Thread Author Time
Re: 6 HAKAN 12:32
postgres sql help James Bond 15:41
Tripping over (my own) stupidity - VARCHAR declaration minus specificity Good, Thomas 17:27
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Adam Cornett 17:51
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity [email protected] 18:09
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Adam Cornett 18:24
Re: Tripping over (my own) stupidity - VARCHAR declaration minus specificity Good, Thomas 18:28

Oct. 15, 2011

Thread Author Time
Group by on Date maya.more 06:51

Oct. 16, 2011

Thread Author Time
Re: postgres sql help Andreas Kretschmer 08:11
Re: postgres sql help Harald Fuchs 08:24
Re: Group by on Date Andreas Kretschmer 08:27
Re: Group by on Date Harald Fuchs 08:35

Oct. 17, 2011

Thread Author Time
Re: postgres sql help Tim Landscheidt 20:44

Oct. 18, 2011

Thread Author Time
new user on mac Scott Swank 21:47

Oct. 19, 2011

Thread Author Time
Re: new user on mac Adam Cornett 02:08
Re: new user on mac Vibhor Kumar 02:43
Re: new user on mac Basil Bourque 08:13
Problem with DROP ROLE Brice André 10:11
Re: Problem with DROP ROLE Andreas Kretschmer 11:32
Re: Problem with DROP ROLE Guillaume Lelarge 11:59
Re: Problem with DROP ROLE Brice André 12:19
How to write sql to access another odbc source. Rich 14:08
How to write query to access another odbc source Rich 15:19
Re: How to write query to access another odbc source Scott Marlowe 15:47
Re: How to write query to access another odbc source pasman pasmański 17:53
Re: How to write query to access another odbc source Rich 19:23

Oct. 20, 2011

Thread Author Time
Re: new user on mac Scott Swank 02:57
Re: new user on mac Guillaume Lelarge 10:22
Re: new user on mac Scott Swank 11:15
Re: new user on mac Samuel Gendler 11:51
Re: new user on mac Thomas Kellerer 12:14

Oct. 21, 2011

Thread Author Time
how to temporally disable foreign key constraint check Emi Lu 13:36
Re: how to temporally disable foreign key constraint check Oliveiros d'Azevedo Cristina 14:58
Question about Escaping text when calling pgplsql functions Matthias Howell 15:38
Re: how to temporally disable foreign key constraint check Emi Lu 15:47
Re: how to temporally disable foreign key constraint check Thomas Kellerer 17:04
Re: how to temporally disable foreign key constraint check Craig Ringer 23:51

Oct. 22, 2011

Thread Author Time
advice on how to store variable attributes Linos 10:41
Re: advice on how to store variable attributes David Johnston 12:53
Re: advice on how to store variable attributes Pavel Stehule 14:07
Re: advice on how to store variable attributes David Johnston 14:28
Re: advice on how to store variable attributes Pavel Stehule 14:33
Re: advice on how to store variable attributes Linos 15:39
Re: advice on how to store variable attributes Pavel Stehule 16:05
Re: advice on how to store variable attributes Scott Swank 16:06
Re: advice on how to store variable attributes David Johnston 16:10
Re: advice on how to store variable attributes Linos 17:14

Oct. 23, 2011

Thread Author Time
To having or not to having? 📎 Ferruccio Zamuner 21:12
Re: To having or not to having? Ferruccio Zamuner 22:55

Oct. 24, 2011

Thread Author Time
RPostgreSQL Win32 package Jira, Marcel 07:15
Re: RPostgreSQL Win32 package tuan 16:51
Handling mutliple clients access with views Brice André 19:23
Re: new user on mac Guillaume Lelarge 21:24

Oct. 25, 2011

Thread Author Time
CTE or Subselect and outer joins not behaving as expected? Joel Stevenson 00:46
Re: CTE or Subselect and outer joins not behaving as expected? bricklen 01:46
Re: Handling mutliple clients access with views Craig Ringer 02:54
Re: Handling mutliple clients access with views David Johnston 03:36
Re: Handling mutliple clients access with views Craig Ringer 03:50
Re: Handling mutliple clients access with views bricklen 03:52
Re: Handling mutliple clients access with views Brice André 06:02
Re: How to write sql to access another odbc source. Craig Ringer 07:59
Re: CTE or Subselect and outer joins not behaving as expected? Harald Fuchs 12:42
how to use explain analyze alan 14:12
optimize self-join query Ty Busby 18:37

Oct. 26, 2011

Thread Author Time
Re: CTE or Subselect and outer joins not behaving as expected? Joel Stevenson 17:22

Oct. 27, 2011

Thread Author Time
How to obtain a coalesce aggregation in a GROUP BY query? Federico Dal Maso 10:28
Re: how to use explain analyze Brent Dombrowski 17:06

Oct. 28, 2011

Thread Author Time
Re: optimize self-join query Tom Lane 00:26

Browse Archives

Prev | Next