agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedtrigger to access only the last transaction
2015-03-08 22:01 UTC avpro avpro <avprowebeden@gmail.com>
` Re: trigger to access only the last transaction
2015-03-09 07:29 UTC Marcos Almeida Azevedo <marcos.al.azevedo@gmail.com>
` Re: trigger to access only the last transaction
2015-03-09 07:46 UTC Frank Pinto <frank@ayalo.co>
` Re: trigger to access only the last transaction
2015-03-09 07:50 UTC avpro avpro <avprowebeden@gmail.com>
` Re: trigger to access only the last transaction
2015-03-09 07:50 UTC avpro avpro <avprowebeden@gmail.com>
` Re: trigger to access only the last transaction
2015-03-09 08:00 UTC Frank Pinto <frank@ayalo.co>
` Re: trigger to access only the last transaction
2015-03-09 08:32 UTC s d <daku.sandor@gmail.com>
[7+ messages in thread]
Schema for caching message-count in folders using triggers
2015-03-05 19:45 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Schema for caching message-count in folders using triggers
2015-03-05 19:59 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Schema for caching message-count in folders using triggers
2015-03-05 20:04 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Schema for caching message-count in folders using triggers
2015-03-05 20:31 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Schema for caching message-count in folders using triggers
2015-03-05 21:16 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Schema for caching message-count in folders using triggers
2015-03-05 21:20 UTC Andreas Joseph Krogh <andreas@visena.com>
[6+ messages in thread]
Advisory locks
2015-02-11 10:32 UTC Tom Paynter <tompaynter@tdpe.co.uk>
` Re: Advisory locks
2015-02-11 10:40 UTC daku.sandor@gmail.com
` Re: Advisory locks
2015-02-11 10:49 UTC Tom Paynter <tompaynter@tdpe.co.uk>
[3+ messages in thread]
Implementing incremental client updates
2015-02-10 11:39 UTC Nii Gii <nkgm.realm@gmail.com>
` Re: Implementing incremental client updates
2015-02-10 13:05 UTC Glyn Astill <glynastill@yahoo.co.uk>
[2+ messages in thread]
Re: How to insert in a table the error returns by query
2015-01-28 16:55 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: How to insert in a table the error returns by query
2015-01-28 17:49 UTC ciamblex <gianluca.civiello@yahoo.it>
` Re: How to insert in a table the error returns by query
2015-01-28 18:22 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: How to insert in a table the error returns by query
2015-01-28 18:52 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: How to insert in a table the error returns by query
2015-01-28 19:03 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: How to insert in a table the error returns by query
2015-01-29 18:01 UTC Marc Mamin <M.Mamin@intershop.de>
[6+ messages in thread]
check if the same function is already running, then exit!
2015-01-26 19:58 UTC Suresh Raja <suresh.rajaabc@gmail.com>
` Re: check if the same function is already running, then exit!
2015-01-26 20:01 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: check if the same function is already running, then exit!
2015-01-26 20:05 UTC Andy Colson <andy@squeakycode.net>
[3+ messages in thread]
commit inside a function failing
2015-01-23 19:56 UTC Suresh Raja <suresh.rajaabc@gmail.com>
` Re: [SQL] commit inside a function failing
2015-01-23 20:00 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: commit inside a function failing
2015-01-23 20:04 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] commit inside a function failing
2015-01-23 20:06 UTC ktm@rice.edu <ktm@rice.edu>
` Re: commit inside a function failing
2015-01-24 15:26 UTC Christopher Browne <cbbrowne@sympatico.ca>
[5+ messages in thread]
Better way to compute moving averages?
2015-01-23 22:58 UTC Jason Aleski <jason.aleski@gmail.com>
` Re: Better way to compute moving averages?
2015-01-24 00:50 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Better way to compute moving averages?
2015-01-24 02:36 UTC Jason Aleski <jason.aleski@gmail.com>
[3+ messages in thread]
fifo stock calculation with window function
2015-01-16 10:07 UTC Dmitry Teslenko <dteslenko@gmail.com>
pg_stat_acvtivity
2015-01-11 12:29 UTC Marcin Krawczyk <jankes.mk@gmail.com>
` Re: pg_stat_acvtivity
2015-01-11 13:47 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Use a TEXT string which is an output from a function for executing a new query in postgres
2015-01-07 18:12 UTC Roy Blum <blumroy@gmail.com>
` Re: Use a TEXT string which is an output from a function for executing a new query in postgres
2015-01-07 18:16 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Use a TEXT string which is an output from a function for executing a new query in postgres
2015-01-08 00:08 UTC Craig Ringer <craig@2ndquadrant.com>
[3+ messages in thread]
Count values that match elements in csv string
2015-01-07 00:05 UTC sqlnewbie2015 <cara.esu@gmail.com>
` Re: Count values that match elements in csv string
2015-01-07 02:21 UTC David G Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Add new field with auto-icrement to existing table
2015-01-06 16:31 UTC Brice André <brice@famille-andre.be>
` Re: Add new field with auto-icrement to existing table
2015-01-06 17:44 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Add new field with auto-icrement to existing table
2015-01-06 20:26 UTC Brice André <brice@famille-andre.be>
[3+ messages in thread]
localtime(0)
2014-12-29 16:31 UTC Suresh Raja <suresh.rajaabc@gmail.com>
` Re: localtime(0)
2014-12-29 16:39 UTC Rene Romero Benavides <rene.romero.b@gmail.com>
` Re: localtime(0)
2014-12-29 16:39 UTC Jonathan S. Katz <jonathan.katz@excoventures.com>
[3+ messages in thread]
foregin table insert error
2014-12-14 09:13 UTC Ed Rahn <edsrahn@gmail.com>
` Re: foregin table insert error
2014-12-14 14:30 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: foregin table insert error
2014-12-14 16:49 UTC Ed Rahn <edsrahn@gmail.com>
` Re: foregin table insert error
2014-12-14 18:39 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: foregin table insert error
2014-12-14 18:53 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[5+ messages in thread]
querying with index on jsonb slower than standard column. Why?
2014-12-07 22:59 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 00:19 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 00:43 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 00:53 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 01:05 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 01:15 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 01:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 15:31 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 15:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 15:50 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 16:44 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 16:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-08 20:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 21:14 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-08 21:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: querying with index on jsonb slower than standard column. Why?
2014-12-08 21:34 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-08 21:39 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-12 21:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-12 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Re: querying with index on jsonb slower than standard column. Why?
2014-12-12 22:10 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-12 23:27 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-13 01:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-13 03:05 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Re: [SQL] querying with index on jsonb slower than standard column. Why?
2014-12-13 05:38 UTC Claudio Freire <klaussfreire@gmail.com>
[24+ messages in thread]
Check/unique constraint question
2006-03-05 08:25 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Check/unique constraint question
2006-03-05 09:02 UTC Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: Check/unique constraint question
2006-03-05 09:49 UTC Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: Check/unique constraint question
2006-03-05 10:05 UTC Volkan YAZICI <yazicivo@ttnet.net.tr>
` Re: Check/unique constraint question
2006-03-05 10:29 UTC Karsten Hilbert <Karsten.Hilbert@gmx.net>
` Re: Check/unique constraint question
2006-03-05 11:50 UTC Michael Glaesemann <grzm@myrealbox.com>
` Re: Check/unique constraint question
2006-03-05 18:32 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: Check/unique constraint question
2014-12-09 18:01 UTC Scott Rohde <srohde@illinois.edu>
` Re: Check/unique constraint question
2014-12-09 18:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Check/unique constraint question
2014-12-09 22:06 UTC Scott Rohde <srohde@illinois.edu>
` Re: Check/unique constraint question
2014-12-09 22:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
rolling window without aggregation
2014-12-05 07:25 UTC Huang, Suya <Suya.Huang@au.experian.com>
` Re: rolling window without aggregation
2014-12-05 07:35 UTC David G Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Querying with arrays
2014-11-27 13:09 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: Querying with arrays
2014-11-27 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with arrays
2014-11-27 16:55 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: Querying with arrays
2014-12-04 13:42 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: Querying with arrays
2014-12-04 13:54 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: Querying with arrays
2014-12-04 19:56 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
[6+ messages in thread]
generating the average 6 months spend excluding first orders
2014-11-26 03:00 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 03:53 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 04:56 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 14:35 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 17:37 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 17:50 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 17:55 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 18:04 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 18:19 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 18:21 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 18:34 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 19:26 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-11-26 19:51 UTC Ron256 <ejaluronaldlee@gmail.com>
` Re: generating the average 6 months spend excluding first orders
2014-12-03 14:42 UTC Ron256 <ejaluronaldlee@gmail.com>
[14+ messages in thread]
regr_slope function with auto creation of X column
2014-11-30 00:27 UTC Jason Aleksi <jason.aleski@gmail.com>
` Re: regr_slope function with auto creation of X column
2014-11-30 03:01 UTC David G Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
pl/pgsql examples
2014-11-21 15:48 UTC Suresh Raja <suresh.rajaabc@gmail.com>
` Re: pl/pgsql examples
2014-11-21 15:59 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: pl/pgsql examples
2014-11-21 19:08 UTC Oliver Christina <oliveiros.cristina@gmail.com>
[3+ messages in thread]
slow sub-query problem
2014-11-17 18:34 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: slow sub-query problem
2014-11-17 18:44 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: slow sub-query problem
2014-11-17 19:19 UTC David Johnston <david.g.johnston@gmail.com>
` Re: slow sub-query problem
2014-11-17 20:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow sub-query problem
2014-11-18 08:53 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: slow sub-query problem
2014-11-18 08:57 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
` Re: slow sub-query problem
2014-11-19 01:37 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: slow sub-query problem
2014-11-19 09:27 UTC daku.sandor@gmail.com
` Re: slow sub-query problem
2014-11-19 17:58 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: slow sub-query problem
2014-11-20 14:12 UTC Tim Dudgeon <tdudgeon.ml@gmail.com>
[10+ messages in thread]
matching against start/end times and diagnostic values (was: filtering based on table of start/end times)
2014-11-12 21:49 UTC Seb <spluque@gmail.com>
` Re: matching against start/end times and diagnostic values
2014-11-14 17:04 UTC Seb <spluque@gmail.com>
[2+ messages in thread]
Using aggregates to get sums and partial sums in one query
2014-11-08 01:18 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Using aggregates to get sums and partial sums in one query
2014-11-10 15:33 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Using aggregates to get sums and partial sums in one query
2014-11-10 16:19 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Using aggregates to get sums and partial sums in one query
2014-11-10 18:52 UTC Andreas Joseph Krogh <andreas@visena.com>
[4+ 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