From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
---|---|
To: | pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Arrays and DBD:Pg |
Date: | 2002-10-31 15:30:13 |
Message-ID: | B9E6FD05.A804%a.witney@sghms.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Has anyone tried fetching array slices through perl DBI/DBD:Pg?
If you send a statement like this
my $sth = $dbh->prepare("select cube[1:2][1][1] from test4");
Then the :1 gets treated as a placeholder and gets substituted. From the
trace
dbd_st_execute: statement = >select cube[1NULL][1][1] from test4<
ERROR: parser: parse error at or near "NULL" at character 14 error 7
recorded: ERROR: parser: parse error at or near "
NULL" at character 14
As no parameters have been bound to the placeholder then a NULL is
substituted and so it fails.
Anyone found a way around this?
Thanks
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-10-31 20:21:36 | Will there be tar files of separated interfaces? |
Previous Message | Bruce Momjian | 2002-10-30 05:06:08 | Re: API Question v7.3 |