Re: [GENERAL] json function question

Yes I meant equivalence in the roundtrip conversion sense. And of course the "feature complete" solution which can handle deep structures would be really nice to have. Best Regards Dan S 2016-02-23 21:11 GMT+01:00 David G. Johnston <david.g.johns...@gmail.com>: > On Tue, Fe

[GENERAL] json function question

orks well. I have this table, data and query: create table test ( id int, txt text, txt_arr text[], f float ); insert into test values (1,'jkl','{abc,def,fgh}',3.14159),(2,'hij','{abc,def,fgh}',3.14159),(2,null,null,null),(3,'def',null,0); select j, json_populate_record(null::test, j) from ( select to_json(t) as j from test t ) r Best Regards Dan S

Re: [GENERAL] question about window function in C

2014-12-27 6:43 GMT+01:00 Merlin Moncure mmonc...@gmail.com: On Fri, Dec 26, 2014 at 11:41 PM, Merlin Moncure mmonc...@gmail.com wrote: On Fri, Dec 26, 2014 at 1:19 PM, Dan S strd...@gmail.com wrote: Well I'm trying to implement a window-function that works on range_types and produces

[GENERAL] question about window function in C

properly after the last call to my window function ? I'm running PostgreSQL 9.3.5 on i686-pc-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit Best Regards Dan S

Re: [GENERAL] question about window function in C

questions like what are the maximum number of simultaneously overlapping ranges and at which ranges the maximum occurs) Best Regards Dan S 2014-12-26 18:57 GMT+01:00 Tom Lane t...@sss.pgh.pa.us: Dan S strd...@gmail.com writes: I'm trying to write a window function in C . In the function I'm

[GENERAL] strange result from query, bug ?

is volatile ? Best Regards Dan S P.S. I've since rewritten the query like below to get the expected results but I still thought I should ask if it is a bug. with cte as ( select generate_series,(random()*999.0)::int + 1 as id from generate_series(1,1000) ) select (select id from random_draw where

Re: [GENERAL] strange result from query, bug ?

Ahh yes, I understand now. Thanks ! Best Regards Dan S 2014-07-28 18:28 GMT+02:00 Tom Lane t...@sss.pgh.pa.us: Dan S strd...@gmail.com writes: I've run into a strange problem with a query. I wonder if it might be a bug or a misunderstanding from my side. Steps to recreate the problem

Re: [GENERAL] Bug in GET STACKED DIAGNOSTICS ?

It would be nice with a consistent behaviour, with the callstack always looking the same despite different causes of the exception. I think it is violating the 'Principle of least astonishment' . Best Regards Dan S 2012/12/11 Pavel Stehule pavel.steh...@gmail.com Hello 2012/12/10 Dan S strd

Re: [GENERAL] Bug in GET STACKED DIAGNOSTICS ?

I got another unexpected behaviour of the call stack by this invocation : select testfunc2(true) from generate_series(1,10); The first call stack is different from the nine folllowing. Shouldn't it be identical to the others ? Best Regards Dan S 2012/12/11 Pavel Stehule pavel.steh

Re: [GENERAL] strange type name in information_schema

So is there always an underscore prepended to the type name of an array ? for example float[] would then be _float right ? Best Regards Dan S 2011/5/21 Pavel Stehule pavel.steh...@gmail.com Hello type array of text has name _text Regards Pavel Stehule 2011/5/21 Dan S strd...@gmail.com

Re: [GENERAL] strange type name in information_schema

Is there any examples of how to join the system tables to get the same information as I was trying to get from the function ? Best Regards Dan S 2011/5/21 Pavel Stehule pavel.steh...@gmail.com 2011/5/21 Dan S strd...@gmail.com: So is there always an underscore prepended to the type name

Re: [GENERAL] strange type name in information_schema

I'll try that . Thank you very much for your help. Best Regards Dan S 2011/5/21 Pavel Stehule pavel.steh...@gmail.com 2011/5/21 Dan S strd...@gmail.com: Is there any examples of how to join the system tables to get the same information as I was trying to get from the function ? you

[GENERAL] counterintuitive behaviour in pl/pgsql

IS NOT NULL) THEN cond := ' col1 $1 '; END IF; IF (cond IS NOT NULL) THEN stmt := stmt || 'where ' || cond; END IF; RETURN QUERY EXECUTE stmt USING i; RETURN; END; $$ language plpgsql; select * from dynamic_query(4); Best Regards Dan S

Re: [GENERAL] counterintuitive behaviour in pl/pgsql

Yes throwing an error would probably be good to catch these kind of mistakes which silently gives you the wrong answer otherwise. Best Regards Dan S 2011/5/21 Tom Lane t...@sss.pgh.pa.us Dan S strd...@gmail.com writes: And yes I do know that I can fix the problem by renaming the output

[GENERAL] strange type name in information_schema

where r.routine_name = 'test' and p.specific_name = r.specific_name and p.specific_catalog=r.specific_catalog and p.specific_schema=r.specific_schema Best Regards Dan S

[GENERAL] How do I do this in plpgsql ?

Hi ! Is there a way to use plpgsql copy type to get an array of a certain type ? For example if I have a type sample%TYPE How can I declare a variable that is an array of sample%TYPE I can't get it to work, is there a way to do it ? Best Regards Dan S

Re: [GENERAL] How do I do this in plpgsql ?

way then. Thank you Merlin and Pavel for your quick answers Dan S 2011/3/18 Merlin Moncure mmonc...@gmail.com On Fri, Mar 18, 2011 at 2:20 PM, Dan S strd...@gmail.com wrote: Hi ! Is there a way to use plpgsql copy type to get an array of a certain type ? For example if I have a type

[GENERAL] timestamp convert to date

Hi List ! I'm running PostgreSQL 8.3.10 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3 (Ubuntu 9.04) I want to use -infinity,infinity as my date interval maximum endpoints in an application I'm writing . Is it possible to use date ? I did a test but it looks

Re: [GENERAL] timestamp convert to date

. Is there a description or manual page on how to install a beta in paralell with my 8.3.10 installation ? regards //Dan 2010/4/30 Tom Lane t...@sss.pgh.pa.us Dan S strd...@gmail.com writes: I did a test but it looks like date doesn't support infinity as a value. Try 8.4 or later