|
From: <gha...@fr...> - 2001-11-23 17:40:58
|
On Fri, 23 Nov 2001, Louis B. Moore wrote: > I'm trying my first SQL-Ledger installation, using Postgres on a Debian > box (Potato which implies postgres 6.5). In due course of creating the > database I get: > > ERROR: parser: parse error at or near "select" insert into tax > (chart_id,rate) values ((select id from chart where accno = 2310),0.07); > > It appears that postgres 6.5 isn't able to do the parenthetical select, > is this problem resolved with postgres 7.x? I run Debian testing/unstable and unstable systems with PostgreSQL. The completely "unstable" system has SQL-Ledger, and it works. Or at least the version of SQL-Ledger installed on it works. I may not be quite up to date. Gord |