X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BF01D5E46D8 for ; Sun, 22 Aug 2004 17:13:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18725-09 for ; Sun, 22 Aug 2004 20:13:35 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 92C045E46CE for ; Sun, 22 Aug 2004 17:13:34 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i7MKDYiG024053 for ; Sun, 22 Aug 2004 20:13:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7MJpYQl018705 for pgsql-sql@postgresql.org; Sun, 22 Aug 2004 19:51:34 GMT From: "Kathrine S" X-Newsgroups: comp.databases.postgresql.sql Subject: ERROR: Invalid regular expression: parentheses ( ) not balanced Lines: 13 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: Date: Sun, 22 Aug 2004 21:51:34 +0200 X-Complaints-To: news-abuse@wol.dk Organization: Customer of Tiscali A/S To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME X-Spam-Level: X-Archive-Number: 200408/272 X-Sequence-Number: 18769 Below is a copy of my sql sentence including the error I am getting. What does the error mean? What have I done wrong? kathrirs=# insert into faglaerer kathrirs-# values ('f-001', '13056802876', 'Petter Lær', lo_import('/home/studenter/it03/kathrirs/img/img01.jpg'), kathrirs(# '2001-12-25', 100, 'Professor', 'A', 1, '{"linux","programmering","matematikk","neutrale nettverk"}', kathrirs(# 12, 'petter.laer@dih.no', '8212'); ERROR: Invalid regular expression: parentheses ( ) not balanced