Re: How to use embedded sql to define an array

On Mon, Jun 10, 2002 at 11:07:52AM -0500, Jeffrey Graham wrote:
> Can someone please tell me how to declare an array of double (float8)
> using esql when you
> don't know how long the array is until runtime?

How do you define the attribute in pgsql? I take it you cannot enter a
dimension here either.

>...
> for ( unsigned int i=0; i < myVector.length(); i++ )
> m_data[i] = myVector[i];
>
> EXEC SQL
> insert into eraDATA
> ( data )
> VALUES( :m_data );
> return sqlOK();

If you just need a way to insert the data you could write your data to a
string together with the insert command so that you end up with a
string:

insert into eraDATA ( data ) VALUES('{1,2,3,....}')

This string can be executed using EXECUTE IMMEDIATE.

Or did you mean something else?

Hope this helps.

Michael

--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!