pgsql-sql  

Messages by Thread

• • [SQL] Edit multiple rows concurrent save Péter Szabó
  • Re: [SQL] Edit multiple rows concurrent save Jasen Betts
• [SQL] how to calculate differences of timestamps? Andreas
  • Re: [SQL] how to calculate differences of timestamps? Tim Landscheidt
  • Re: [SQL] how to calculate differences of timestamps? Steve Crawford
• [SQL] Better way to check more than 1 value NOT IN (...) Andreas
  • Re: [SQL] Better way to check more than 1 value NOT IN (...) pasman pasmański
• [SQL] Howto build a funtion that selects an id or inserts a value Andreas
• [SQL] help with xpath namespace Brian Sherwood
  • Re: [SQL] help with xpath namespace Filip Rembiałkowski
  • Re: [SQL] help with xpath namespace Brian Sherwood
  • Re: [SQL] help with xpath namespace Ross Reedstrom
• [SQL] a spatial table's bounding box Asli Akarsakarya
  • Re: [SQL] a spatial table's bounding box Filip Rembiałkowski
  • Re: [SQL] a spatial table's bounding box Asli Akarsakarya
• [SQL] using the aggregate function max() John Fabiani
  • Re: [SQL] using the aggregate function max() David Johnston
  • Re: [SQL] using the aggregate function max() John Fabiani
  • [SQL] use of savepoint in containter managed transaction Amar Dhole
  • Re: [SQL] using the aggregate function max() Thomas Kellerer
• [SQL] ambiguous local variable name in 9.0 proc Samuel Gendler
  • Re: [SQL] ambiguous local variable name in 9.0 proc David Johnston
  • Re: [SQL] ambiguous local variable name in 9.0 proc Samuel Gendler
  • Re: [SQL] ambiguous local variable name in 9.0 proc Tom Lane
• [SQL] Combining several CTEs with a recursive CTE Thomas Kellerer
  • Re: [SQL] Combining several CTEs with a recursive CTE David Johnston
  • Re: [SQL] Combining several CTEs with a recursive CTE Thomas Kellerer
  • [SQL] handling duplicate row exception Amar Dhole
  • Re: [SQL] handling duplicate row exception Filip Rembiałkowski
  • Re: [SQL] handling duplicate row exception Amar Dhole
  • Re: [SQL] handling duplicate row exception Filip Rembiałkowski
• [SQL] select xpath ... boris
  • Re: [SQL] select xpath ... Rob Sargent
  • Re: [SQL] select xpath ... boris
  • Re: [SQL] select xpath ... Brian Sherwood
  • Re: [SQL] select xpath ... Ross J. Reedstrom
• [SQL] insert or update within transaction Andreas
  • Re: [SQL] insert or update within transaction Josh Kupershmidt
• [SQL] Sorting of data from two tables R. Smith
  • Re: [SQL] Sorting of data from two tables David Johnston
  • Re: [SQL] Sorting of data from two tables R. Smith
  • Re: [SQL] Sorting of data from two tables David Johnston
• [SQL] Passing function parameters to regexp_replace Leif Biberg Kristensen
  • Re: [SQL] Passing function parameters to regexp_replace Leif Biberg Kristensen
  • Re: [SQL] Passing function parameters to regexp_replace Tim Landscheidt
  • Re: [SQL] Passing function parameters to regexp_replace Leif Biberg Kristensen
  • Re: [SQL] Passing function parameters to regexp_replace Tim Landscheidt
• [SQL] Clever way to check overlapping time intervals ? Andreas
  • Re: [SQL] Clever way to check overlapping time intervals ? Andreas Kretschmer
  • Re: [SQL] Clever way to check overlapping time intervals ? pasman pasmański
  • Re: [SQL] Clever way to check overlapping time intervals ? Frank Bax
• [SQL] Window function sort order help Dianna Harter
  • Re: [SQL] Window function sort order help Nicoletta Maia
  • Re: [SQL] Window function sort order help Thomas Kellerer
  • Re: [SQL] Window function sort order help Tim Landscheidt
  • Re: [SQL] Window function sort order help Dianna Harter
  • Re: [SQL] Window function sort order help nicoletta maia
  • Re: [SQL] Window function sort order help Dianna Harter
  • Re: [SQL] Window function sort order help Nicoletta Maia
• [SQL] Partition over a sliding date window Guillaume Roger
• [SQL] Use select and update together Boris
  • Re: [SQL] Use select and update together pasman pasmański
  • Re: [SQL] Use select and update together Andreas
  • Re: [SQL] Use select and update together Guillaume Lelarge
  • Re: [SQL] Use select and update together Tom Lane
  • Re: [SQL] Use select and update together Samuel Gendler
• [SQL] FW: Hi Mandana Mokhtary
  • Re: [SQL] FW: Hi Adrian Klaver
  • Re: [SQL] FW: Hi Craig Ringer
  • [SQL] FW: Hi Mandana Mokhtary
• [SQL] Dynamic sql Gabriel Filipiak
  • Re: [SQL] Dynamic sql Jasen Betts
• [SQL] Re: how can I get the length of columns of a table by system tables/views shuaixf
  • Re: [SQL] Re: how can I get the length of columns of a table by system tables/views msi77
• [SQL] My Trigger is not working :( Waqar Azeem
  • Re: [SQL] My Trigger is not working :( pasman pasmański
  • Re: [SQL] My Trigger is not working :( Waqar Azeem
• [SQL] How can I inherit constraints? Andreas
• [SQL] Schema partitioning Charlie
  • Re: [SQL] Schema partitioning David Johnston
  • Re: [SQL] Schema partitioning Little, Douglas
• [SQL] Want some basic compare of data type on PostgreSQL and MySQL bhavesh1385
  • Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe
  • Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL Leif Biberg Kristensen
  • Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL Scott Marlowe
  • Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL Samuel Gendler
  • Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL Jasen Betts
• [SQL] function based index problem Viktor Bojović
  • Re: [SQL] function based index problem David Johnston
  • Re: [SQL] function based index problem Viktor Bojović
  • Re: [SQL] [ADMIN] function based index problem Kevin Grittner
• [SQL] ERROR: cannot subscript type text because it is not an array lxnf98mm
• [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Julien Cigar
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Tom Lane
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emre Hasegeli
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Emi Lu
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Pavel Stehule
  • Re: [SQL] where col1 not ilike ('str1%', 'str2%'... 'strN%') support? Jasen Betts
• [SQL] Need a little help with geometric query lxnf98mm
  • Re: [SQL] Need a little help with geometric query Samuel Gendler
• [SQL] st_offsetcurve ppdcc
  • Re: [SQL] st_offsetcurve Brent Dombrowski
• [SQL] Add one column to another gvim
  • Re: [SQL] Add one column to another Tony Capobianco
  • Re: [SQL] Add one column to another Oliveiros d'Azevedo Cristina
  • Re: [SQL] Add one column to another Scott Marlowe
  • Re: [SQL] Add one column to another vipul shah
  • Re: [SQL] Add one column to another David Johnston
  • Re: [SQL] Add one column to another Tim Landscheidt
• [SQL] new table with a select ppdcc
  • Re: [SQL] new table with a select Julien Cigar
  • Re: [SQL] new table with a select Florian Weimer
  • [SQL] new table with a select ppdcc
  • Re: [SQL] new table with a select MIkhail Puzanov
• [SQL] need magic to shuffle some numbers Andreas
  • Re: [SQL] need magic to shuffle some numbers Samuel Gendler
  • Re: [SQL] need magic to shuffle some numbers Tim Landscheidt
• [SQL] WITH RECURSIVE question Julien Cigar
  • Re: [SQL] WITH RECURSIVE question Julien Cigar
• [SQL] Confused about writing this stored procedure/method. JavaNoobie
  • Re: [SQL] Confused about writing this stored procedure/method. Pavel Stehule
  • Re: [SQL] Confused about writing this stored procedure/method. Jasen Betts
  • Re: [SQL] Confused about writing this stored procedure/method. Tim Landscheidt
• [SQL] sorting months according to fiscal year Enzen user
  • Re: [SQL] sorting months according to fiscal year Pavel Stehule
  • Re: [SQL] sorting months according to fiscal year Gavin Flower
• [SQL] exclusion constraint for ranges of IP Herouth Maoz
  • Re: [SQL] exclusion constraint for ranges of IP Harald Fuchs
  • Re: [SQL] exclusion constraint for ranges of IP Herouth Maoz
  • Re: [SQL] exclusion constraint for ranges of IP Simone Sanfratello
  • Re: [SQL] exclusion constraint for ranges of IP Misa Simic
  • Re: [SQL] exclusion constraint for ranges of IP Harald Fuchs
  • Re: [SQL] exclusion constraint for ranges of IP Jasen Betts
  • Re: [SQL] exclusion constraint for ranges of IP Herouth Maoz
  • Re: [SQL] exclusion constraint for ranges of IP Samuel Gendler
  • Re: [SQL] exclusion constraint for ranges of IP Jasen Betts
  • Re: [SQL] exclusion constraint for ranges of IP Herouth Maoz
• [SQL] (pgsql8.4) DATA Corruption Mikola Rose
  • Re: [SQL] (pgsql8.4) DATA Corruption Scott Marlowe
  • Re: [SQL] (pgsql8.4) DATA Corruption Mik Rose
  • Re: [SQL] (pgsql8.4) DATA Corruption Craig Ringer
• [SQL] Cursor names in a self-nested function Kidd, David M
  • Re: [SQL] Cursor names in a self-nested function Pavel Stehule
  • Re: [SQL] Cursor names in a self-nested function Tom Lane
• [SQL] parsing audit table M. D.
  • Re: [SQL] parsing audit table Jaime Casanova
  • Re: [ADMIN] [SQL] parsing audit table Jan Eskilsson
• [SQL] which is better: using OR clauses or UNION? adam_pgsql
  • Re: [SQL] which is better: using OR clauses or UNION? Viktor Bojović
  • Re: [SQL] which is better: using OR clauses or UNION? adam_pgsql
  • Re: [SQL] which is better: using OR clauses or UNION? David Johnston
  • Re: [SQL] which is better: using OR clauses or UNION? Tom Lane
  • Re: [SQL] which is better: using OR clauses or UNION? adam_pgsql
  • Re: [SQL] which is better: using OR clauses or UNION? Igor Neyman
  • Re: [SQL] which is better: using OR clauses or UNION? Jasen Betts
  • Re: [SQL] which is better: using OR clauses or UNION? Igor Neyman
  • [SQL] which is better: using OR clauses or UNION? Adam Witney
• [SQL] F_TABLE_NUMBER_RANGE equivalent in Postgresql Yuan HOng
  • Re: [SQL] F_TABLE_NUMBER_RANGE equivalent in Postgresql msi77
  • Re: [SQL] F_TABLE_NUMBER_RANGE equivalent in Postgresql Pavel Stehule
• [SQL] Calculate the ratio Andreas Forø Tollefsen
  • Re: [SQL] Calculate the ratio msi77
  • Re: [SQL] Calculate the ratio David Johnston
  • Re: [SQL] Calculate the ratio David Johnston
  • Re: [SQL] Calculate the ratio Andreas Forø Tollefsen
• [SQL] bigint and unix time Janiv Ratson
  • Re: [SQL] bigint and unix time Adrian Klaver
  • Re: [SQL] bigint and unix time Janiv Ratson
  • Re: [SQL] bigint and unix time Adrian Klaver
  • Re: [SQL] bigint and unix time Janiv Ratson
  • Re: [SQL] bigint and unix time Adrian Klaver
  • Re: [SQL] bigint and unix time Janiv Ratson
  • Re: [SQL] bigint and unix time Janiv Ratson
• [SQL] pgadmin debugger David Harel
  • Re: [SQL] pgadmin debugger Adrian Klaver
  • Re: [SQL] pgadmin debugger David Harel
  • Re: [SQL] pgadmin debugger Adrian Klaver
  • Re: [SQL] pgadmin debugger David Harel
  • Re: [SQL] pgadmin debugger Adrian Klaver
  • Re: [SQL] pgadmin debugger David Harel
• [SQL] Using variables in select tlund79
  • Re: [SQL] Using variables in select Oliveiros d'Azevedo Cristina
• [SQL] Stuck Up In My Own Category Tree Don Parris
  • Re: [SQL] Stuck Up In My Own Category Tree Samuel Gendler
  • Re: [SQL] Stuck Up In My Own Category Tree jasmin . dizdarevic
  • Re: [SQL] Stuck Up In My Own Category Tree Edward W. Rouse
  • Re: [SQL] Stuck Up In My Own Category Tree Don Parris
• [SQL] Mysterious column "name" Nikolay
  • Re: [SQL] Mysterious column "name" Oliveiros d'Azevedo Cristina
  • Re: [SQL] Mysterious column "name" Steve Crawford
  • Re: [SQL] Mysterious column "name" Tom Lane
• [SQL] Problem with nested left-joins and coalesce ai
  • Re: [SQL] Problem with nested left-joins and coalesce Carla
  • Re: [SQL] Problem with nested left-joins and coalesce ai
  • Re: [SQL] Problem with nested left-joins and coalesce Carla
• [SQL] Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar

• Earlier messages
• Later messages