On Wed, Aug 31, 2005 at 03:17:29PM -0400, Frank wrote:
> This fails to insert records
>
> >> insert into category values
> >> (4, 'Hardware - Monitor', 2, '2004-10-12 10:50:01'),
> >> (5, 'Hardware - Printer', 2, '2004-10-12 10:50:02'),
> >> (6, 'Hardware - Terminal', 2, '2004-10-12 10:50:02'),
PostgreSQL doesn't support this form of INSERT; you'll have to use
a separate INSERT per record or use COPY. Another method, although
probably not useful in this case, is to insert records from a subquery;
see the INSERT documentation for more information.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
