[SQL] Which type of functions are best?

2004-10-19 Thread Postgres User
Hi, I'm just starting out and am looking to speed up queries using either SQL functions or PLPGSQL functions. I have googled around and have not found a great answer saying that this is the way to go. I would like to use PREPARE/EXECUTE... but of course they only last for each connection, I w

[SQL] varray? table of varchar?

2004-04-07 Thread Postgres User
Hi, I posted asking about varray a few days ago. Also I've run into an Oracle type that is defined as "table of varchar2(4000) index by binary_integer". Has anyone encountered either of these before? I'm not exactly sure what they do as I'm not an Oracle expert. So it is hard for me to see wha

[SQL] oracle varray functionality?

2004-04-05 Thread Postgres User
I've run across a custom type in an oracle database that I am porting to PostGreSQL: create or replace type number_varray as varray(1000) of number; Is the int4array example the same as this? create type int4array(input=int4array_in,output=int4array_out, internallength=variable,element=int4)