Re: [SQL] Can we convert from Postgres to Oracle !!???

On Sun, Oct 22, 2006 at 12:03:38AM +0300, Devrim GUNDUZ wrote: > On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote: > > Can we convert from Postgres to Oracle !!??? You can also run our software and get Oracle syntax for 1/25th the cost. -- Jim Nasby

Re: [SQL] plpgsql record as parameter ???

On 10/18/06, Andy <[EMAIL PROTECTED]> wrote: Hi, I have the following function:   CREATE OR REPLACE FUNCTION zahlavis_rech_list(int4, varchar(10)) RETURNS "varchar" AS$BODY$DECLAREavis_id ALIAS FOR $1;rech_type ALIAS FOR $2;rech_list text;sql text;rec RECORD;BEGIN   rech_list := '';sql :=

Re: [SQL] Add calculated fields from one table to other table

> I have two tables. Tick table has fields like ticker, time, price & volume > and Timeseries > table has fields like ticker, time, avg_price, avg_volume. > > The time field in Timeseries table is different from time in tick table, > its the timeseries > for every minute. Now I want to ca