That works like a charm. Thanks, Alvaro!
-Jeff
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 08, 2007 1:22 PM
To: Demel, Jeff
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] COPY FROM - force a value
Demel, Jeff wrote:
> Is there a way
Is there a way to force a value when you're doing a COPY FROM, importing
a file into a table?
Here's my query as it is now:
COPY filetable (value1, value2, value3, value4, forcevalue1,
forcevalue2)
FROM 'C:\\InsertFiles\\thisfile.txt'
WITH DELIMITER AS ' '
;
The file only contains data for
;t have to juggle users, permissions, and settings.
-Jeff
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 08, 2007 3:06 AM
To: Demel, Jeff
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] metaphone and nysiis in postgres
Demel, Jeff wrote:
>
Can this be installed easily on Windows?
-Jeff
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Demel, Jeff
Sent: Wednesday, February 07, 2007 2:13 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] metaphone and nysiis in postgres
Ah! Cool. Contrib
Ah! Cool. Contrib/fuzzystrmatch has metaphone. Looks like it has
soundex and levenschtein too.
Thanks!
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 07, 2007 2:09 PM
To: Demel, Jeff
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] metaphone and
Microsoft SQL server has two extended stored procedures that I need in
Postgres: xp_nysiis and xp_metaphone. They do fuzzy matching on strings. Are
there Postgres alternatives for these? Or maybe some other way to do
phonetic/fuzzy matching that would be as effective?
-Jeff
-Original M
> So, I'm wondering if NOCOUNT is supported in Postgres at all. If it's
> not, what's the alternative? If it is, what is wrong with my syntax?
Andrew wrote:
Not as far as I know. What's it supposed to do?
It suppresses the rowcount returned after the query runs.
> I haven't gotten there yet,
I'm converting a MSSQL query to postgresql. It's something like this:
SET NOCOUNT ON;
INSERT INTO table_name([list]) VALUES([list]);
SELECT SCOPE_IDENTITY() as newId;
I get an error on the NOCOUNT statement:
"syntax error at or near "on" at character 13"
So, I'm wondering if NOCOUNT is supporte
