Binding array to placeholder (Pg)

mp.82 · #1 (**permalink**) 09-27-05, 02:56

How can I insert an array into a Postgres table?

If I have a table xyz which has a column dates of the type 'timestamp without time zone[]', how can I insert a value into that table?

It DOESN'T work like this:

Code:

my @times = ('2005-09-27 08:46:00', '2005-09-27 08:48:00');

my $sth = prepare("INSERT INTO test.xyz (dates) VALUES (?)");
$sth->execute(\@times);

senza_nome · #2 (**permalink**) 09-27-05, 17:08

Code:

my $time;
foreach $time (@time) {
  $sth->execute($times);
   };

Internet Services

Web Development

Digital Marketing

Consumer Tech