[GENERAL] Multicorn 0.9.1 and 0.9.2 released

This mean that the planner will be able to pick a nested loop over a full foreign scan if a look up by key is advertised as cheaper. Multicorn website: http://multicorn.org Multicorn on PGXN: http://pgxn.org/dist/multicorn/ Best regards, -- Ronan Dunklau -- Sent via pgsql-general mailing

Re: [GENERAL] User-defined Aggregate function and performance.

On 02/04/2012 18:06, Tom Lane wrote: > Ronan Dunklau writes: >> I'm trying to define a "weighted mean" aggregate using postgresql create >> aggregate feature. > >> I've been able to quickly write the required pgsql code to get it >> working, but

[GENERAL] User-defined Aggregate function and performance.

_avg(a, b) from test; -- pure sql version select case when sum(b::numeric) = 0 then 0 else sum(a::numeric * b::numeric) / sum(b::numeric) end from test; -- Ronan Dunklau -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Regular expression character escape

On 24/02/2012 17:43, Heiko Wundram wrote: > Am 24.02.2012 17:40, schrieb Ronan Dunklau: >> On 24/02/2012 17:09, Heiko Wundram wrote: >>> Use the corresponding function of your programming language/framework of >>> choice. E.g. Python delivers this as re.escape(). >>

Re: [GENERAL] Regular expression character escape

On 24/02/2012 17:09, Heiko Wundram wrote: > Am 24.02.2012 17:04, schrieb Ronan Dunklau: >> On 24/02/2012 16:38, David Johnston wrote: >>> You could (should?) write the escaping routine on the server side in >>> a user-defined function: >>> >>> WHE

Re: [GENERAL] Regular expression character escape

submitted_stringliteral) || > '\d*$') I totally agree, but I hoped I could use an already existing function without having to read the whole spec to figure what should and should not be escaped. > David J. > > -- Ronan Dunklau -- Sent via pgsql-general mailing list (pgs

[GENERAL] Regular expression character escape

than at the beginning of the regexp. >From the docs at http://www.postgresql.org/docs/current/static/functions-matching.html: "Embedded options take effect at the ) terminating the sequence. They can appear only at the start of an ARE." Any idea on how to achieve this ? Thank you

[GENERAL] Re: Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw?

. We never tested it under Windows so try it at your own risks :) - -- Ronan Dunklau -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.18 (GNU/Linux) iQEcBAEBAgAGBQJO1MrHAAoJECTYLCgFy323X6IH/Avo7KERwWORjl543QvFnwHs nueyj7m/LUjjBbl/WjtrrRFRFnC1Y2iO4gvJRqVe119KRJBvyxiLqF0mr40U0lWg EGErRf4648xoRL

[GENERAL] First "beta" of multicorn FDW on pgxn

of of concept than anything else. If anyone has the time and/or interest to give some feedback, it would be greatly appreciated. -- Ronan Dunklau

Re: [GENERAL] Postgresql - FDW, ForeignScanState and subqueries

tion, I'll try to move my code in the plan-time hook. Thank you very much ! Best Regards, -- Ronan Dunklau 2011/10/20 Tom Lane > Ronan Dunklau writes: > > Now, if I query my table like this (a subquery, joined on the outer > query), > > what info should I be able t

[GENERAL] Postgresql - FDW, ForeignScanState and subqueries

fields in the struct. Does postgresql really fetch all columns in a subselect, or am I just parsing the tree in a wrong way ? I've tried to look at the oracle-fdw code, but I don't understand what they are doing with params. Thank you ! -- Ronan Dunklau

[GENERAL] Anonymous record type and inner types.

ation propagated somehow (that an_int is an integer, and a_varchar a varchar) ? If so, is it easily accessible in client libraries ? I'm using psycopg2 for python, which itself uses libpq. Thanks. Regards, -- Ronan Dunklau signature.asc Description: This is a digitally signed message part.