agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedMore optimized SQL
2018-01-04 11:59 UTC =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr>
Oacle to Postgres migration
2017-12-26 00:28 UTC Azimuddin Mohammed <azimeiu@gmail.com>
` Re: Oacle to Postgres migration
2017-12-26 01:41 UTC PropAAS DBA <dba@propaas.com>
` Re: Oacle to Postgres migration
2017-12-29 21:48 UTC Francis Santiago <santiagocfc@gmail.com>
[3+ messages in thread]
Oracle to postgres migration
2017-12-26 00:30 UTC Azimuddin Mohammed <azimeiu@gmail.com>
` Re: Oracle to postgres migration
2017-12-26 01:51 UTC John Scalia <jayknowsunix@gmail.com>
` Re: Oracle to postgres migration
2017-12-26 09:36 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: Oracle to postgres migration
2017-12-26 12:32 UTC Timo Myyrä <timo.myyra@bittivirhe.fi>
` Re: Oracle to postgres migration
2017-12-26 13:14 UTC Timo Myyrä <timo.myyra@bittivirhe.fi>
[5+ messages in thread]
High CPU usage in postgres servers
2017-12-25 18:28 UTC nikhil raj <nikhilraj474@gmail.com>
` Fwd: High CPU usage in postgres servers
2017-12-25 18:32 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: High CPU usage in postgres servers
2017-12-25 23:12 UTC Melvin Davidson <melvin6925@gmail.com>
` Re: High CPU usage in postgres servers
2017-12-26 00:19 UTC Michael Paquier <michael.paquier@gmail.com>
[4+ messages in thread]
SQL conformity regarding SQLSTATE
2017-12-19 14:14 UTC Jürgen Purtz <juergen@purtz.de>
` Re: SQL conformity regarding SQLSTATE
2017-12-19 15:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL conformity regarding SQLSTATE
2017-12-20 10:08 UTC Jürgen Purtz <juergen@purtz.de>
` Re: SQL conformity regarding SQLSTATE
2017-12-20 12:02 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: SQL conformity regarding SQLSTATE
2017-12-21 01:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL conformity regarding SQLSTATE
2017-12-21 10:44 UTC Jürgen Purtz <juergen@purtz.de>
` Re: SQL conformity regarding SQLSTATE
2017-12-21 16:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL conformity regarding SQLSTATE
2017-12-22 17:15 UTC Jürgen Purtz <juergen@purtz.de>
[8+ messages in thread]
XML Parsing in Postgresql
2017-12-18 13:50 UTC Abdul Hameedk <hameedka@hcl.com>
` Re: XML Parsing in Postgresql
2017-12-18 14:02 UTC Lutz Horn <lutz.horn@posteo.de>
` Re: XML Parsing in Postgresql
2017-12-18 14:26 UTC Pavel Stehule <pavel.stehule@gmail.com>
[3+ messages in thread]
FILTER clause for non-aggregate window functions
2017-12-12 07:54 UTC Андрей Жиденков <pensnarik@gmail.com>
` Re: FILTER clause for non-aggregate window functions
2017-12-12 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: FILTER clause for non-aggregate window functions
2017-12-12 16:53 UTC Андрей Жиденков <pensnarik@gmail.com>
[3+ messages in thread]
Windowing ?
2017-12-11 17:09 UTC Olivier Leprêtre <o.lepretre@gmail.com>
` Re: Windowing ?
2017-12-11 17:15 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Windowing ?
2017-12-11 18:46 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[3+ messages in thread]
window function ?
2017-12-10 18:33 UTC Olivier Leprêtre <o.lepretre@gmail.com>
` Re: window function ?
2017-12-10 18:48 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[2+ messages in thread]
Timestamp alculation identical to Microsoft Excel results
2017-12-07 09:59 UTC =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr>
` Re: Timestamp alculation identical to Microsoft Excel results
2017-12-07 10:15 UTC Samed YILDIRIM <samed@reddoc.net>
` Re: Timestamp alculation identical to Microsoft Excel results
2017-12-07 17:27 UTC Luuk <luuk.vosslamber@gmail.com>
[3+ messages in thread]
Sv: Not counting duplicates of declared pratition in OVER()-clause
2017-11-28 18:03 UTC Andreas Joseph Krogh <andreas@visena.com>
Not counting duplicates of declared pratition in OVER()-clause
2017-11-28 17:54 UTC Andreas Joseph Krogh <andreas@visena.com>
Roles and security
2017-11-25 20:03 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Roles and security
2017-11-25 23:15 UTC John R Pierce <pierce@hogranch.com>
` Re: Roles and security
2017-11-26 15:18 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[3+ messages in thread]
psql -c "\copy table to test.csv with CSV" - french character is wrong
2017-11-23 16:42 UTC Emi <emilu@encs.concordia.ca>
` Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
2017-11-23 18:24 UTC Pierre Chevalier Géologue <pierrechevaliergeol@free.fr>
` Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
2017-11-23 18:57 UTC Emi <emilu@encs.concordia.ca>
` Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
2017-11-24 06:28 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: psql -c "\copy table to test.csv with CSV" - french character is wrong
2017-11-24 14:47 UTC Emi <emilu@encs.concordia.ca>
[5+ messages in thread]
How to use COPY command with jsonb datatype ?
2017-11-22 12:04 UTC ROS Didier <didier.ros@edf.fr>
` Re: How to use COPY command with jsonb datatype ?
2017-11-22 14:21 UTC bricklen <bricklen@gmail.com>
` Re: How to use COPY command with jsonb datatype ?
2017-11-23 09:05 UTC Hector Vass <hector.vass@metametrics.co.uk>
[3+ messages in thread]
Migration to pglister - Before
2017-11-20 14:33 UTC Stephen Frost <sfrost@snowman.net>
` Re: [ADMIN] Migration to pglister - Before
2017-11-20 15:30 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: [ADMIN] Migration to pglister - Before
2017-11-20 15:34 UTC Stephen Frost <sfrost@snowman.net>
[3+ messages in thread]
Migration to PGLister - After
2017-11-20 14:47 UTC Stephen Frost <sfrost@snowman.net>
Line number returned in Postgres Raise Exception sentence
2017-11-14 10:17 UTC queralt <queraltr@gmail.com>
` Re: Line number returned in Postgres Raise Exception sentence
2017-11-15 08:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Line number returned in Postgres Raise Exception sentence
2017-11-20 12:52 UTC queralt <queraltr@gmail.com>
[3+ messages in thread]
md5 checksum of a previous row
2017-11-13 06:15 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 07:25 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: md5 checksum of a previous row
2017-11-13 07:30 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 07:31 UTC MS (direkt) <martin.stoecker@stb-datenservice.de>
` Re: md5 checksum of a previous row
2017-11-13 07:39 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 07:42 UTC MS (direkt) <martin.stoecker@stb-datenservice.de>
` Re: md5 checksum of a previous row
2017-11-13 07:47 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 07:49 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: md5 checksum of a previous row
2017-11-13 07:56 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 07:57 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: md5 checksum of a previous row
2017-11-13 08:01 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: md5 checksum of a previous row
2017-11-13 08:01 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 08:13 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: md5 checksum of a previous row
2017-11-13 14:11 UTC Iaam Onkara <iamonkara@gmail.com>
` Re: md5 checksum of a previous row
2017-11-13 14:36 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
[15+ messages in thread]
Problems with PARTITION BY with count() in window-func
2017-11-08 10:17 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Problems with PARTITION BY with count() in window-func
2017-11-08 13:50 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Problems with PARTITION BY with count() in window-func
2017-11-08 14:51 UTC MS (direkt) <martin.stoecker@stb-datenservice.de>
[3+ messages in thread]
join tables by nearest timestamp
2017-11-01 05:53 UTC Brice André <brice@famille-andre.be>
` Re: join tables by nearest timestamp
2017-11-01 08:06 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: join tables by nearest timestamp
2017-11-01 08:11 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: join tables by nearest timestamp
2017-11-01 08:47 UTC Brice André <brice@famille-andre.be>
` Re: join tables by nearest timestamp
2017-11-01 13:12 UTC Brice André <brice@famille-andre.be>
` Re: join tables by nearest timestamp
2017-11-02 07:43 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
` Re: join tables by nearest timestamp
2017-11-02 09:31 UTC Brice André <brice@famille-andre.be>
` Re: join tables by nearest timestamp
2017-11-02 14:49 UTC Achilleas Mantzios <achill@matrix.gatewaynet.com>
[8+ messages in thread]
Unable to use INSERT ... RETURNING with column from other table
2017-10-24 22:04 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-24 22:06 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-24 22:49 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 00:21 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 01:56 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 02:45 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 03:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 21:15 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Unable to use INSERT ... RETURNING with column from other table
2017-10-25 21:34 UTC Andreas Joseph Krogh <andreas@visena.com>
[9+ messages in thread]
Re: How to get the list of tables with encrypted columns
2017-10-17 07:54 UTC ROS Didier <didier.ros@edf.fr>
` Re: How to get the list of tables with encrypted columns
2017-10-17 20:46 UTC Klaus Kaisersberger <klaus.kaisersberger@outlook.com>
` Re: How to get the list of tables with encrypted columns
2017-10-17 20:49 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
[3+ messages in thread]
How to index encrypted colums ?
2017-10-16 13:38 UTC ROS Didier <didier.ros@edf.fr>
` Re: How to index encrypted colums ?
2017-10-16 15:47 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
` Re: How to index encrypted colums ?
2017-10-17 07:49 UTC ROS Didier <didier.ros@edf.fr>
` Re: How to index encrypted colums ?
2017-10-17 14:14 UTC Steve Midgley <steve.midgley.mixrun@gmail.com>
` Re: How to index encrypted colums ?
2017-10-17 15:17 UTC ROS Didier <didier.ros@edf.fr>
` Re: How to index encrypted colums ?
2017-10-17 15:37 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: How to index encrypted colums ?
2017-10-17 16:26 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
` Re: How to index encrypted colums ?
2017-10-17 16:46 UTC Steve Midgley <science@misuse.org>
` Re: How to index encrypted colums ?
2017-10-17 18:33 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
` Re: How to index encrypted colums ?
2017-10-17 18:54 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
` Re: How to index encrypted colums ?
2017-10-17 19:18 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
[11+ messages in thread]
Only insert into tables trough functions
2017-10-14 13:36 UTC Alvin Díaz <alvin.rd@live.com>
` Re: Only insert into tables trough functions
2017-10-16 15:31 UTC Klaus Kaisersberger <point-of-entry@outlook.com>
[2+ 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