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