[SQL] Backup error - Pls help

[Kumar]

Hi,
 
I have 2 versions of Postgres server 7.2 & 7.3.4 installed 
on Linux server 7.3. I have not started the Postgres Server 7.2 which is located 
at /var/library/pgsql.
 
I am running and using only 7.3.4 located at 
/usr/local/pgsql.
 
After I login, I come to the /usr/local/pgsql/bin and then 
issued the following
 
 

[EMAIL PROTECTED] bin]$ 
pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prodpg_dump: server version: 
pg_dump.mo; pg_dump version: 7.2.1pg_dump: aborting because of version 
mismatch  (Use the -i option to proceed anyway.)[EMAIL PROTECTED] bin]$ 
pg_dump -h 192.168.2.51 -i -f /home/usr1/prod.sql prod
 
pg_dump: server 
version: pg_dump.mo; pg_dump version: 7.2.1pg_dump: proceeding despite 
version mismatchpg_dump: query to obtain list of data types failed: 
ERROR:  Attribute "typprtlen" not found[EMAIL PROTECTED] 
bin]$
 
Where i am doing 
mistake. Pls shed some light.
 
Thank you very 
much.
 
Kumar

Re: [SQL] Unique Constraint Based on Date Range

[Manfred Koizar]

On Sat, 20 Sep 2003 18:55:34 -0400, Kevin Houle <[EMAIL PROTECTED]>
wrote:
> SELECT INTO result * FROM table_rates WHERE
>   effective_date >= NEW.effective_date AND
>   expiry_date <= NEW.expiry_date AND
>   cost = NEW.cost;
> IF FOUND THEN
>RAISE EXCEPTION ''record overlaps with existing record'';
> END IF;

This only catches complete inclusion of an old range in the new one.
newb-e
old b--e

Try
 WHERE effective_date < NEW.expiry_date
   AND expiry_date > NEW.effective_date

which also detects
newbe
old b---e
old   b--e
old  be

Servus
 Manfred

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] Backup error - Pls help

[Richard Huxton]

On Monday 22 September 2003 10:01, Kumar wrote:
> Hi,
>
> I have 2 versions of Postgres server 7.2 & 7.3.4 installed on Linux server
> 7.3. I have not started the Postgres Server 7.2 which is located at
> /var/library/pgsql.

RedHat 7.3 I guess you mean?

> I am running and using only 7.3.4 located at /usr/local/pgsql.
>
> After I login, I come to the /usr/local/pgsql/bin and then issued the
> following
>
>
> [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prod
> pg_dump: server version: pg_dump.mo; pg_dump version: 7.2.1
> pg_dump: aborting because of version mismatch  (Use the -i option to
> proceed anyway.) [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -i -f
> /home/usr1/prod.sql prod

What directory you are in has nothing to do with which copy of a program you 
will run. There is a utility called "which" to help you: "which pg_dump".
Almost certainly what you want to do is:
  /usr/local/pgsql/bin/pg_dump -h ...

You probably want to get a book on unix/linux and read up about the various 
search paths.
-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[SQL] zero-length string

[Chris_Wu]

All
Hello, Now I'm upgrade postgresql from 7.2.1 to 7.3.3.
But It'can't use zero-length string . It raised error "patoi zero-length
string".
I use redhat linux 7.3.
How to solve this problem.
Thanks

Chris.Wu


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Backup error - Pls help

[Kumar]

While I issue
which pg_dump it is showed me
/usr/local/pg_dump

But how to run the backup utility pg_dump to backup my database.

- Original Message - 
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>; "psql" <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 3:20 PM
Subject: Re: [SQL] Backup error - Pls help


> On Monday 22 September 2003 10:01, Kumar wrote:
> > Hi,
> >
> > I have 2 versions of Postgres server 7.2 & 7.3.4 installed on Linux
server
> > 7.3. I have not started the Postgres Server 7.2 which is located at
> > /var/library/pgsql.
>
> RedHat 7.3 I guess you mean?
>
> > I am running and using only 7.3.4 located at /usr/local/pgsql.
> >
> > After I login, I come to the /usr/local/pgsql/bin and then issued the
> > following
> >
> >
> > [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prod
> > pg_dump: server version: pg_dump.mo; pg_dump version: 7.2.1
> > pg_dump: aborting because of version mismatch  (Use the -i option to
> > proceed anyway.) [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -i -f
> > /home/usr1/prod.sql prod
>
> What directory you are in has nothing to do with which copy of a program
you
> will run. There is a utility called "which" to help you: "which pg_dump".
> Almost certainly what you want to do is:
>   /usr/local/pgsql/bin/pg_dump -h ...
>
> You probably want to get a book on unix/linux and read up about the
various
> search paths.
> -- 
>   Richard Huxton
>   Archonet Ltd


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Fw: [SQL] Backup error - Pls help

[Kumar]

Dear Friend,
I understood what you are saying. But could you pls tell me how to change
the path of the pg_dump so that it should point to
/usr/local/pgsql/bin/pg_dump

Please help

- Original Message - 
From: "Kumar" <[EMAIL PROTECTED]>
To: "Richard Huxton" <[EMAIL PROTECTED]>; "psql" <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 5:16 PM
Subject: Re: [SQL] Backup error - Pls help


> While I issue
> which pg_dump it is showed me
> /usr/local/pg_dump
>
> But how to run the backup utility pg_dump to backup my database.
>
> - Original Message - 
> From: "Richard Huxton" <[EMAIL PROTECTED]>
> To: "Kumar" <[EMAIL PROTECTED]>; "psql" <[EMAIL PROTECTED]>
> Sent: Monday, September 22, 2003 3:20 PM
> Subject: Re: [SQL] Backup error - Pls help
>
>
> > On Monday 22 September 2003 10:01, Kumar wrote:
> > > Hi,
> > >
> > > I have 2 versions of Postgres server 7.2 & 7.3.4 installed on Linux
> server
> > > 7.3. I have not started the Postgres Server 7.2 which is located at
> > > /var/library/pgsql.
> >
> > RedHat 7.3 I guess you mean?
> >
> > > I am running and using only 7.3.4 located at /usr/local/pgsql.
> > >
> > > After I login, I come to the /usr/local/pgsql/bin and then issued the
> > > following
> > >
> > >
> > > [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql
prod
> > > pg_dump: server version: pg_dump.mo; pg_dump version: 7.2.1
> > > pg_dump: aborting because of version mismatch  (Use the -i option to
> > > proceed anyway.) [EMAIL PROTECTED] bin]$ pg_dump -h 192.168.2.51 -i -f
> > > /home/usr1/prod.sql prod
> >
> > What directory you are in has nothing to do with which copy of a program
> you
> > will run. There is a utility called "which" to help you: "which
pg_dump".
> > Almost certainly what you want to do is:
> >   /usr/local/pgsql/bin/pg_dump -h ...
> >
> > You probably want to get a book on unix/linux and read up about the
> various
> > search paths.
> > -- 
> >   Richard Huxton
> >   Archonet Ltd
>


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: Fw: [SQL] Backup error - Pls help

[Richard Huxton]

On Monday 22 September 2003 13:15, Kumar wrote:
> Dear Friend,
> I understood what you are saying. But could you pls tell me how to change
> the path of the pg_dump so that it should point to
> /usr/local/pgsql/bin/pg_dump

There's a guide on the Linux Documentation Project here:
  http://www.tldp.org/HOWTO/Path.html
but it might not be RedHat specific (if that's what you are running).

You probably want to look at /etc/profile - this should be where your path is 
set. It also runs all the files in /etc/profile.d/ (on RedHat)

Perhaps the best method, if you want to keep both versions of PG is to rename 
the "wrong" pg_dump to pg_dump.alt and then you can do (as root)

# cd /usr/bin
# ln -s ../local/pgsql/bin/pg_dump

This will create a link from /usr/bin/pg_dump to /usr/local/pgsql/bin/pg_dump 
which should make it your default.
You can still run the old version as pg_dump.alt - this should help to ensure 
you know which one you are running.

HTH
-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[SQL] Backup error - Please help

[Senthil Kumar S]

Hi,
 
I have 2 versions of Postgres server 7.2 & 7.3.4 installed 
on Linux server 7.3. I have not started the Postgres Server 7.2 which is located 
at /var/library/pgsql.
 
I am running and using only 7.3.4 located at 
/usr/local/pgsql.
 
After I login, I come to the /usr/local/pgsql/bin and then 
issued the following
 
 

[EMAIL PROTECTED] bin]$ 
pg_dump -h 192.168.2.51 -f /home/usr1/prod.sql prodpg_dump: server version: 
pg_dump.mo; pg_dump version: 7.2.1pg_dump: aborting because of version 
mismatch  (Use the -i option to proceed anyway.)[EMAIL PROTECTED] bin]$ 
pg_dump -h 192.168.2.51 -i -f /home/usr1/prod.sql prod
 
pg_dump: server 
version: pg_dump.mo; pg_dump version: 7.2.1pg_dump: proceeding despite 
version mismatchpg_dump: query to obtain list of data types failed: 
ERROR:  Attribute "typprtlen" not found[EMAIL PROTECTED] 
bin]$
 
Where i am doing 
mistake. Pls shed some light.
 
Thank you very 
much.
 
Kumar

Re: [SQL] selecting duplicate records

[Christoph Haller]

> 1. How to select duplicate records only from a single table using a
select
> query.
>
e.g.
select sid,count(sid) from location group by sid having count(sid)>1;

Do you get the idea?
Your request is pretty unspecific, so if this is not what you're asking
for,
try again.

Regards, Christoph



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] auto_increment

[Bruno Wolff III]

On Mon, Sep 22, 2003 at 09:15:04 +0400,
  sad <[EMAIL PROTECTED]> wrote:
> On Saturday 20 September 2003 10:23, you wrote:
> > On Sat, 2003-09-20 at 06:10, Muhyiddin A.M Hayat wrote:
> > > How to Create auto_increment field in PostreSQL.
> > > Can I create them using Trigger.
> >
> > Use the SERIAL datatype.  See also the functions nextval(), currval()
> > and setval().
> 
> I believe it is better to EXPLICITLY declare a SEQUENCE and 
> set the default value nextval() to the field.

The disadvantage of that system is that the dependency isn't detected.
With serial type you won't be able to drop the sequence without
dropping the column and when you drop the table, the sequence will
get dropped as well. (The preceding applies to 7.4. Things may not
be checked as well in 7.3.)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] GiST and full text search

[Wei Weng]

Hi all.

I have been doing a little research on how to do full text search under 
postgresql, and GiST seems to be the way to go. But the documentation on 
this is pretty lacking and I wonder if there are better sources that 
describe the details on how to implement full text search with GiST.

Thanks

Wei


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

Re: [SQL] GiST and full text search

[Richard Huxton]

On Monday 22 September 2003 16:02, Wei Weng wrote:
> Hi all.
>
> I have been doing a little research on how to do full text search under
> postgresql, and GiST seems to be the way to go. But the documentation on
> this is pretty lacking and I wonder if there are better sources that
> describe the details on how to implement full text search with GiST.

Have you looked at tsearch / tsearch2 in the contrib/ directory?

-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [SQL] GiST and full text search

[Wei Weng]

The production server uses PostgreSQL 7.3.1 right now, so I am only 
looking at contrib/tsearch.

I read through the README file. It only seems to offer a way to FTS 
through one 'text' column in the table. How do I create a 'txtidx' column 
that combines two or even more 'text' columns in the table?

Thanks

Wei

On Mon, 22 Sep 2003, Richard Huxton wrote:

> On Monday 22 September 2003 16:02, Wei Weng wrote:
> > Hi all.
> >
> > I have been doing a little research on how to do full text search under
> > postgresql, and GiST seems to be the way to go. But the documentation on
> > this is pretty lacking and I wonder if there are better sources that
> > describe the details on how to implement full text search with GiST.
> 
> Have you looked at tsearch / tsearch2 in the contrib/ directory?
> 
> 

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

[SQL] Using sql statements in file

[Suresh Basandra]

Hi,

 

I would like to do the following using files:

 

1. put create database, create
tables sql statements in a file and execute through prompt

2. insert or update data that is
put in a file

 

Please let me know if there are any examples that lists how sql
statements can be 
put in a file and used.

 

Thanks

Suresh Basandra

Re: [SQL] Using sql statements in file

[Wei Weng]

try psql -f filename


On Mon, 22 Sep 2003, Suresh Basandra wrote:

> Hi,
>  
> I would like to do the following using files:
>  
> 1. put create database, create tables sql statements in a file and
> execute through prompt
> 2. insert or update data that is put in a file
>  
> Please let me know if there are any examples that lists how sql
> statements can be  put in a file and used.
>  
> Thanks
> Suresh Basandra
> 

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

[SQL] Using sql statements in file

[Suresh Basandra]

Hi,

 

I would like to do the following using files:

 

1. put create database, create
tables sql statements in a file and execute through prompt

2. insert or update data that is
put in a file

 

Please let me know if there are any examples that lists how
sql statements can be  put
in a file and used.

 

Thanks

Suresh Basandra

Re: [SQL] GiST and full text search

[Richard Huxton]

On Monday 22 September 2003 16:41, Wei Weng wrote:
> The production server uses PostgreSQL 7.3.1 right now, so I am only
> looking at contrib/tsearch.
>
> I read through the README file. It only seems to offer a way to FTS
> through one 'text' column in the table. How do I create a 'txtidx' column
> that combines two or even more 'text' columns in the table?

According to README.tsearch from 7.4beta (not tsearch2 which is the new one)

Current syntax allows creating trigger for several columns
you want to be searchable:

  create trigger txtidxupdate before update or insert on titles
  for each row execute procedure tsearch(titleidx, title1, title2,... );

Perhaps see what 7.3.4's tsearch says - that should be compatible with 7.3.1
-- 
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [SQL] GiST and full text search

[Andrew J. Kopciuch]

On Monday 22 September 2003 09:41, Wei Weng wrote:
> The production server uses PostgreSQL 7.3.1 right now, so I am only
> looking at contrib/tsearch.
>

tsearch2 is compatible, and available for any version of PosgreSQL 7.3.  It is 
not included in the contrib directory.  It is available in CVS head and will 
be in 7.4 contrib AFAIK.

You can download the stable version here:

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz

There are full installation instructions in the introdution.  See below.

> I read through the README file. It only seems to offer a way to FTS
> through one 'text' column in the table. How do I create a 'txtidx' column
> that combines two or even more 'text' columns in the table?
>

Read the introduction documentation.  It explains this in detail, plus many 
other things you might want to know:

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html


Andy

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] Backup of multiple tables

[Andreas Joseph Krogh]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Friday 19 September 2003 17:38, Tom Lane wrote:
> Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> > I usually backup my database with pg_backup without the -t option. But
> > now I need to only backup certain tables(say tab1 and tab2), is this
> > possible with pg_dump? I've tried with "pg_dump -t tab1 -t tab2" without
> > success.
>
> pg_dump can only handle one -t option at a time.  It'd make sense to
> allow multiple -t options (likewise -n) but no one's got round to
> improving the code in that particular direction.  I don't think it would
> be hard; want to fix it and send in a patch?

I've never looked at the code-base of pgsql before, but I'll give it a try. 
Don't expect anything real soon tho.

- -- 
Andreas Joseph Krogh <[EMAIL PROTECTED]>
Managing Director, Senior Software Developer
OfficeNet AS

- - Writing software is more fun than working.

gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/b3jeUopImDh2gfQRAhP3AKCwsviN37+7ZAG4x4hI/ErQEyKmHACfW4on
EI900FlO/lDInoDnf9nDEM0=
=Xcq/
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Backup of multiple tables

[Dan Langille]

On 23 Sep 2003 at 0:34, Andreas Joseph Krogh wrote:

> On Friday 19 September 2003 17:38, Tom Lane wrote:
>
> > pg_dump can only handle one -t option at a time.  It'd make sense to
> > allow multiple -t options (likewise -n) but no one's got round to
> > improving the code in that particular direction.  I don't think it would
> > be hard; want to fix it and send in a patch?
> 
> I've never looked at the code-base of pgsql before, but I'll give it a try. 
> Don't expect anything real soon tho.

If you do deliver, I for one will buy you a beer should we ever meet. 
 I'm sure others would feel simlarly obliged.
-- 
Dan Langille : http://www.langille.org/


---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [SQL] Backup of multiple tables

[Bertrand Petit]

On Tue, Sep 23, 2003 at 12:34:00AM +0200, Andreas Joseph Krogh wrote:
> 
> I've never looked at the code-base of pgsql before, but I'll give it a try. 
> Don't expect anything real soon tho.

If you acheive to add the selection of tables to dump, you may
at the same time try to add a similar option but working schemas. And,
yes, there's a beer waiting for you here too!

-- 
%!PS
297.6 420.9 translate 90 rotate 0 setgray gsave 0 1 1{pop 0 180 moveto 100
180 170 100 170 -10 curveto 180 -9 180 -9 190 -10 curveto 190 100 100 180
0 180 curveto fill 180 rotate}for grestore/Bookman-LightItalic findfont
240 scalefont setfont -151.536392 -63.7998886 moveto (bp)show showpage

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] Oracle 'connect by prior' now eaiser in 7.3?

[Merrall, Graeme]

I'll start by admitting that I've not looked at it myself yet but I'm
just wondering if any others have looked at this yet. A while ago we
migrated a complex web-app from Oracle to postgres. It went very well
when it came to replace 'connect by prior'.  Because we were time poor
we couldn't spend much time looking the best way to emulate this in
postgres and the stored procs seemed complex.  One look at the OpenACS
information sent me screaming for the hills :)

Given a table of 
PARENT_NODE_ID   NOT NULL NUMBER
CHILD_NODE_IDNOT NULL NUMBER
ORDINAL   NUMBER

And Oracle SQL of 
select child_node_id, level
from node_relationships
connect by prior child_node_id = parent_node_id
start with parent_node_id=10
order by Hierarchy.Branch(level, ordinal)

Am I right in thinking that recursive procedures and procs returning row
sets would allow us to better emulate this behaviour? As anyone looked
at it yet?

Cheers,
 Graeme

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

[SQL] unsubscribe

[Rudi Starcevic]

unsubscribe

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] selecting duplicate records

[Christopher Browne]

The world rejoiced as [EMAIL PROTECTED] (Christoph Haller) wrote:
>> 1. How to select duplicate records only from a single table using a
> select
>> query.
>>
> e.g.
> select sid,count(sid) from location group by sid having count(sid)>1;
>
> Do you get the idea?
> Your request is pretty unspecific, so if this is not what you're asking
> for,
> try again.

The aggregate is likely to perform horrifically badly.  Here might
be an option:

Step 1.  Find all of the duplicates...

select a.* into temp table sid from some_table a, some_table b
  where a.oid < b.oid and
a.field1 = b.field1 and
a.field2 = b.field2 and
a.field3 = b.field3 and
 ...
a.fieldn = b.fieldn;

Step 2.  Look for the matching entries in the source table...

select a.* from some_table a, sid b
  where
a.field1 = b.field1 and
a.field2 = b.field2 and
a.field3 = b.field3 and
 ...
a.fieldn = b.fieldn;

[There's a weakness here; if there are multiple dupes, they may get
picked multiple times in the second query :-(.]
-- 
If this was helpful,  rate me
http://cbbrowne.com/info/rdbms.html
As Will Rogers would have said, "There is no such thing as a free
variable."  -- Alan Perlis

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [SQL] Oracle 'connect by prior' now eaiser in 7.3?

[Joe Conway]

Merrall, Graeme wrote:
Am I right in thinking that recursive procedures and procs returning row
sets would allow us to better emulate this behaviour? As anyone looked
at it yet?
See connectby() in contrib/tablefunc. Someone was working on SQL99 
recursive queries but it didn't get done for 7.4 -- perhaps it will be 
in 7.5. In the meantime, connectby() is in 7.3 and might work for you.

HTH,

Joe

---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [SQL] Using sql statements in file

[A.Bhuvaneswaran]

> 1. put create database, create tables sql statements in a file and
> execute through prompt
> 2. insert or update data that is put in a file

Place your commands in a file & execute them either from the prompt or
from psql. Remember to create your file in the below order:

1) create database
2) connect to new database (\c)
3) create tables/views/functions ...
4) insert/update commands

regards,
bhuvaneswaran



---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [SQL] GiST and full text search

[Oleg Bartunov]

On Mon, 22 Sep 2003, Wei Weng wrote:

> The production server uses PostgreSQL 7.3.1 right now, so I am only
> looking at contrib/tsearch.

you may download tsearch2 for 7.3.X from
http://www.sai.msu.su/~megera/postgres/gist/tsearc/V2

>
> I read through the README file. It only seems to offer a way to FTS
> through one 'text' column in the table. How do I create a 'txtidx' column
> that combines two or even more 'text' columns in the table?
>
> Thanks
>
> Wei
>
> On Mon, 22 Sep 2003, Richard Huxton wrote:
>
> > On Monday 22 September 2003 16:02, Wei Weng wrote:
> > > Hi all.
> > >
> > > I have been doing a little research on how to do full text search under
> > > postgresql, and GiST seems to be the way to go. But the documentation on
> > > this is pretty lacking and I wonder if there are better sources that
> > > describe the details on how to implement full text search with GiST.
> >
> > Have you looked at tsearch / tsearch2 in the contrib/ directory?
> >
> >
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>

Regards,
Oleg
_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]