agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
SQL error: function round(double precision, integer) does not exist
  2005-02-27 23:26 UTC  TJ O'Donnell <tjo@acm.org>
` Re: SQL error: function round(double precision, integer) does
  2005-02-28 09:12 UTC  Richard Huxton <dev@archonet.com>
` Re: [despammed] SQL error: function round(double precision, integer) does not exist
  2005-02-28 09:12 UTC  Andreas Kretschmer <akretschmer@despammed.com>
` Re: SQL error: function round(double precision, integer) does not exist
  2005-02-28 10:43 UTC  Din Adrian <adrian.din@easynet.ro>
` Re: SQL error: function round(double precision, integer) does not
  2005-02-28 13:37 UTC  Christoph Haller <ch@rodos.fzk.de>
` Re: SQL error: function round(double precision, integer) does
  2005-02-28 14:40 UTC  TJ O'Donnell <tjo@acm.org>
` Re: SQL error: function round(double precision, integer) does not exist
  2005-02-28 16:33 UTC  Michael Fuhr <mike@fuhr.org>
` Re: SQL error: function round(double precision, integer) does
  2005-02-28 17:12 UTC  TJ O'Donnell <tjo@acm.org>
` Re: SQL error: function round(double precision, integer) does not exist
  2005-02-28 17:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: SQL error: function round(double precision, integer) does
  2005-02-28 21:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 17:26 UTC  Vladimir Nicolici <vladnc@gmail.com>
` Re: Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 17:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 17:55 UTC  Vladimir Nicolici <vladnc@gmail.com>
` Re: Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 17:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 18:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: SQL error: function round(double precision, integer) does not exist
  2017-05-25 18:23 UTC  Vladimir Nicolici <vladnc@gmail.com>
  [16+ messages in thread]

TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef
  2017-05-22 10:51 UTC  Sebastien FLAESCH <sf@4js.com>
` Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef
  2017-05-22 10:57 UTC  Sebastien FLAESCH <sf@4js.com>
` Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef
  2017-05-22 11:07 UTC  Sebastien FLAESCH <sf@4js.com>
` Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef
  2017-05-22 11:14 UTC  Sebastien FLAESCH <sf@4js.com>
` Re: TRUNCATE TABLE corrupts pg_class.relfilenode = pg_attrdef.pg_attrdef
  2017-05-22 12:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

SQL conversion help
  2017-05-20 04:01 UTC  =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr>
` Re: SQL conversion help
  2017-05-20 04:07 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: SQL conversion help
  2017-05-20 13:24 UTC  =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr>
` Re: SQL conversion help
  2017-05-20 13:38 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: SQL conversion help
  2017-05-22 06:30 UTC  Thomas Kellerer <spam_eater@gmx.net>
  [5+ messages in thread]

PostgrSQL server : CPU and Memory
  2017-05-18 03:50 UTC  kaustubh kelkar <ksquare16@gmail.com>
` Re: PostgrSQL server : CPU and Memory
  2017-05-18 04:03 UTC  John R Pierce <pierce@hogranch.com>
  [2+ messages in thread]

PostgreSQL 9.3 DB initialization issue
  2017-05-13 13:11 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: PostgreSQL 9.3 DB initialization issue
  2017-05-13 13:25 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] PostgreSQL 9.3 DB initialization issue
  2017-05-13 13:41 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: [SQL] PostgreSQL 9.3 DB initialization issue
  2017-05-13 14:00 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] PostgreSQL 9.3 DB initialization issue
  2017-05-13 14:58 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: PostgreSQL 9.3 DB initialization issue
  2017-05-13 15:53 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: PostgreSQL 9.3 DB initialization issue
  2017-05-13 16:44 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] PostgreSQL 9.3 DB initialization issue
  2017-05-13 16:49 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: PostgreSQL 9.3 DB initialization issue
  2017-05-13 21:50 UTC  Steve Midgley <science@misuse.org>
` Re: [SQL] PostgreSQL 9.3 DB initialization issue
  2017-05-13 22:26 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [10+ messages in thread]

DB initialization/ Upgrade issue
  2017-05-13 12:43 UTC  Ashish Tiwari <tashish786@gmail.com>
` Re: DB initialization/ Upgrade issue
  2017-05-13 12:59 UTC  Thomas Kellerer <spam_eater@gmx.net>
  [2+ messages in thread]

exporting query result
  2017-05-12 09:14 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: [SQL] exporting query result
  2017-05-12 13:12 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] exporting query result
  2017-05-12 15:58 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: [SQL] exporting query result
  2017-05-12 16:07 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: exporting query result
  2017-05-12 16:20 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: exporting query result
  2017-05-12 16:21 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: exporting query result
  2017-05-12 18:03 UTC  Günce Kaya <guncekaya14@gmail.com>
  [7+ messages in thread]

Most recent row
  2017-05-05 08:25 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: Most recent row
  2017-05-05 08:32 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
` Re: Most recent row
  2017-05-05 08:50 UTC  vinny <vinny@xs4all.nl>
` Re: Most recent row
  2017-05-05 09:13 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: Most recent row
  2017-05-05 09:35 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: Most recent row
  2017-05-05 09:44 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: Most recent row
  2017-05-05 10:00 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: Most recent row
  2017-05-05 10:54 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: Most recent row
  2017-05-05 11:09 UTC  hubert depesz lubaczewski <depesz@depesz.com>
` Re: Most recent row
  2017-05-05 15:14 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Most recent row
  2017-05-05 16:02 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Most recent row
  2017-05-05 20:47 UTC  Michael Moore <michaeljmoore@gmail.com>
` Re: Most recent row
  2017-05-05 21:25 UTC  Michael Moore <michaeljmoore@gmail.com>
` Re: Most recent row
  2017-05-05 21:57 UTC  Michael Moore <michaeljmoore@gmail.com>
` Re: Most recent row
  2017-05-07 23:57 UTC  Bob Edwards <bob@cs.anu.edu.au>
` Re: Most recent row
  2017-05-08 11:49 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: Most recent row
  2017-05-08 12:19 UTC  Thomas Kellerer <spam_eater@gmx.net>
  [17+ messages in thread]

Please advice on query optimization
  2017-04-20 16:43 UTC  Muhannad Shubita <muhannadshubita@gmail.com>
` Re: Please advice on query optimization
  2017-04-20 17:18 UTC  Samed YILDIRIM <samed@reddoc.net>
` Re: Please advice on query optimization
  2017-04-20 17:35 UTC  Muhannad Shubita <muhannadshubita@gmail.com>
` Re: Please advice on query optimization
  2017-04-20 19:29 UTC  Samed YILDIRIM <samed@reddoc.net>
` Re: Please advice on query optimization
  2017-04-20 19:37 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Please advice on query optimization
  2017-04-20 20:07 UTC  Muhannad Shubita <muhannadshubita@gmail.com>
` Re: Please advice on query optimization
  2017-04-20 22:04 UTC  Hector Vass <hector.vass@metametrics.co.uk>
  [7+ messages in thread]

Best way to store Master-Detail Data
  2017-04-13 03:51 UTC  Alvin Díaz <alvin.rd@live.com>
` Re: Best way to store Master-Detail Data
  2017-04-13 04:15 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Best way to store Master-Detail Data
  2017-04-13 10:54 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Best way to store Master-Detail Data
  2017-04-13 13:08 UTC  Alvin Díaz <alvin.rd@live.com>
  [4+ messages in thread]

CTEs and re-use
  2017-04-12 00:41 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: CTEs and re-use
  2017-04-12 01:47 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: CTEs and re-use
  2017-04-12 02:47 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: CTEs and re-use
  2017-04-12 03:05 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: CTEs and re-use
  2017-04-12 04:04 UTC  Rosser Schwarz <rosser.schwarz@gmail.com>
` Re: CTEs and re-use
  2017-04-12 16:29 UTC  Rob Sargent <robjsargent@gmail.com>
  [6+ messages in thread]

death of array?
  2017-04-07 02:32 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: death of array?
  2017-04-07 03:02 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: death of array?
  2017-04-07 06:28 UTC  Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: death of array?
  2017-04-07 15:22 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: death of array?
  2017-04-07 15:26 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: death of array?
  2017-04-07 15:57 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: death of array?
  2017-04-07 16:02 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: death of array?
  2017-04-07 16:17 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: death of array?
  2017-04-08 21:07 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: death of array?
  2017-04-10 06:50 UTC  Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: death of array?
  2017-04-10 14:41 UTC  Rob Sargent <robjsargent@gmail.com>
  [11+ messages in thread]

Crosstab function
  2005-04-06 06:55 UTC  bandeng <postgredb@gmail.com>
` Re: Crosstab function
  2005-04-06 08:25 UTC  Richard Huxton <dev@archonet.com>
` Re: [despammed] Crosstab function
  2005-04-06 08:32 UTC  Andreas Kretschmer <akretschmer@despammed.com>
` Re: [despammed] Crosstab function
  2005-04-07 09:46 UTC  bandeng <postgredb@gmail.com>
` Re: [despammed] Crosstab function
  2005-04-07 11:36 UTC  Markus Schaber <schabi@logix-tt.com>
` Crosstab function
  2017-04-02 16:05 UTC  Gowtham Vel <c8gowthamvel@gmail.com>
` Re: Crosstab function
  2017-04-03 14:39 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Crosstab function
  2017-04-04 18:28 UTC  Gowtham Vel <c8gowthamvel@gmail.com>
` Re: Crosstab function
  2017-04-05 17:04 UTC  Gowtham Vel <c8gowthamvel@gmail.com>
` Re: Crosstab function
  2017-04-06 00:01 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [10+ messages in thread]

Query Advice
  2017-03-30 18:03 UTC  Gary Chambers <gwchamb@gwcmail.com>
` Re: Query Advice
  2017-03-30 18:13 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Query Advice
  2017-03-30 18:16 UTC  Vincent Elschot <vinny@xs4all.nl>
` Re: Query Advice
  2017-03-30 18:17 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Query Advice
  2017-03-30 18:27 UTC  Jason Aleski <jason.aleski@gmail.com>
` Re: Query Advice
  2017-03-30 19:19 UTC  Gary Chambers <gwc@gwcmail.com>
` Re: Query Advice
  2017-03-30 19:22 UTC  Gary Chambers <gwchamb@gwcmail.com>
  [7+ messages in thread]

daisychain rows to detect value
  2017-03-27 09:58 UTC  Gary Stainburn <gary.stainburn@ringways.co.uk>
` Re: daisychain rows to detect value
  2017-03-27 15:59 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [2+ messages in thread]

Column widening without outage
  2017-03-27 08:29 UTC  Aniruddha Deshpande <daniruddha29@gmail.com>

Equivalent data type for SQL_Variant not found
  2017-03-20 13:12 UTC  Ghosh, Snehashish <snehashish.ghosh@capgemini.com>
` Re: Equivalent data type for SQL_Variant not found
  2017-03-20 13:54 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

parameter type is unknown error
  2017-03-06 11:28 UTC  Günce Kaya <guncekaya14@gmail.com>
` Fwd: parameter type is unknown error
  2017-03-06 11:36 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: Fwd: parameter type is unknown error
  2017-03-06 11:51 UTC  Charles Clavadetscher <clavadetscher@swisspug.org>
` Re: Fwd: parameter type is unknown error
  2017-03-06 11:57 UTC  Raymond O'Donnell <rod@iol.ie>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:00 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:20 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:22 UTC  Charles Clavadetscher <clavadetscher@swisspug.org>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:36 UTC  Günce Kaya <guncekaya14@gmail.com>
` Re: Fwd: parameter type is unknown error
  2017-03-06 12:51 UTC  Charles Clavadetscher <clavadetscher@swisspug.org>
` Re: parameter type is unknown error
  2017-03-06 13:27 UTC  Samed YILDIRIM <samed@reddoc.net>
` Re: Fwd: parameter type is unknown error
  2017-03-06 14:12 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Fwd: parameter type is unknown error
  2017-03-06 14:20 UTC  Charles Clavadetscher <clavadetscher@swisspug.org>
` Re: Fwd: parameter type is unknown error
  2017-03-07 04:18 UTC  Günce Kaya <guncekaya14@gmail.com>
  [14+ messages in thread]

avoid update - insert churn
  2017-03-05 18:20 UTC  Kevin Duffy <kevind0718@gmail.com>
` Re: avoid update - insert churn
  2017-03-05 19:56 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: avoid update - insert churn
  2017-03-05 20:07 UTC  Kevin Duffy <kevind0718@gmail.com>
` Re: avoid update - insert churn
  2017-03-06 03:55 UTC  Steve Midgley <science@misuse.org>
  [4+ messages in thread]

FDW Process ID (PID)
  2017-02-28 06:35 UTC  Gaurav Tomar <gauravtomar14@gmail.com>
` Re: FDW Process ID (PID)
  2017-02-28 17:03 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: FDW Process ID (PID)
  2017-02-28 17:07 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [3+ messages in thread]

Question on MERGE in postgresql
  2017-02-18 15:32 UTC  Kaleeswaran Velu <kaleeswaran.velu@gmail.com>
` Re: Question on MERGE in postgresql
  2017-02-18 15:39 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [2+ messages in thread]

Conditional Lookup Table with Like
  2017-02-16 22:19 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-16 22:37 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-16 23:05 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-16 23:32 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-17 00:37 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-17 15:33 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-17 16:41 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-17 17:56 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
` Re: Conditional Lookup Table with Like
  2017-02-17 17:58 UTC  sqlQuestions <ryanpgodfrey@gmail.com>
  [9+ messages in thread]

function source code not returning from inside a pgsql function.
  2017-02-09 16:39 UTC  Herwig Goemans <herwig.goemans@gmail.com>
` Re: function source code not returning from inside a pgsql function.
  2017-02-09 16:44 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: function source code not returning from inside a pgsql function.
  2017-02-09 16:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: function source code not returning from inside a pgsql function.
  2017-02-09 17:29 UTC  Herwig Goemans <herwig.goemans@gmail.com>
  [4+ messages in thread]

Problem wil TIMEZONE vs TIME ZONE
  2017-02-08 11:20 UTC  Mike Wes <mikeewes@gmail.com>
` Re: Problem wil TIMEZONE vs TIME ZONE
  2017-02-08 14:32 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Problem wil TIMEZONE vs TIME ZONE
  2017-02-08 15:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
  2017-02-07 10:53 UTC  Herwig Goemans <herwig.goemans@gmail.com>
` Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
  2017-02-07 16:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.
  2017-02-08 10:20 UTC  Herwig Goemans <herwig.goemans@gmail.com>
  [3+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox