On Mon, 7 Jun 2010, Armaghan Saqib wrote:
Try following query as well.
SELECT * FROM acc_trans WHERE transdate IS NULL;
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
aesi=# SELECT * FROM acc_trans WHERE transdate IS NULL;
trans_id | chart_id | amount | transdate | source | approved |
fx_transaction | project_id | memo | id | cleared | vr_id | entry_id
----------+----------+--------+-----------+--------+----------+----------------+------------+------+----+---------+-------+----------
(0 rows)
Sigh, DB dump later today.
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
