Re: [HACKERS] Proposal for Allow postgresql.conf values to be changed via SQL

2012-10-29 Thread Chris Corbyn
What's the use case of this? It sounds like it will just create a maintenance nightmare where some stuff you expect to lookup in in postgresql.conf is actually hiding in the .auto file. Assuming only super users/sysadmins would have the ability to change things in the config file, wouldn't they

Re: [HACKERS] Should "select 'nan'::float = 'nan'::float;" return false as per IEEE 754

2012-10-28 Thread Chris Corbyn
Would this introduce problems finding rows where the stored value is NaN? You'd need to add a function or operator to avoid that. Il giorno 28/ott/2012, alle ore 20:43, Hannu Krosing ha scritto: > This is how PostgreSQL currently works - > > test=# select 'NaN'::float = 'NaN'::float as must_be_

[HACKERS] Is PQexecParams() simply a wrapper function?

2012-09-22 Thread Chris Corbyn
Hi All, I'm currently using PQexecParams() as part of a bridge to allow Postgres to be used in another programming language. Not specifying the OIDs simplifies things (for the end user), but bytea params still cause headaches, since they need to be formatted differently and I receive the data a