Re: [SQL] 7.1 REFERENCES contstraints

On Sun, 6 May 2001, Michael Richards wrote: > I see that the REFERENCES constraint is a little more restrictive in > 7.1. I need to have a table with a constraint so one of it's columns > must exist in a second table. This is not a key, since there may be N > columns in the second table that m

[SQL] 7.1 REFERENCES contstraints

I see that the REFERENCES constraint is a little more restrictive in 7.1. I need to have a table with a constraint so one of it's columns must exist in a second table. This is not a key, since there may be N columns in the second table that match. Any ideas on how I should create this? CREATE

Re: [SQL] update error

"guard" <[EMAIL PROTECTED]> writes: > update table_a set trn_no = table_b.trn_no from table_a,table_b > where table_a.cust_no=table_b.cust_no > IN pgsql 7.0x IS OK > if run 7.1 IS error ?? More details please? regards, tom lane ---(end of broad

Re: [SQL] create table

On Sun, Apr 29, 2001 at 09:34:29PM +0200, LeoDeBeo wrote: > can anybody explain me the syntax of Create Table documentation?? ... > i also don't understand what the [ ... ] and [, ... ] means. I do know that > brackets denote options and | alternatives. I guess: ``[ ... ]'' means that you may

[SQL] update error

I try update table_a set trn_no = table_b.trn_no from table_a,table_b where table_a.cust_no=table_b.cust_no IN pgsql 7.0x IS OK if run 7.1 IS error ?? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED

Re: [SQL] Need help with search-and-replace

On Sunday 06 May 2001 10:27, Josh Berkus wrote: > Folks, > > I need to strip certain columns out of my pgdump file. However, I > can't figure out how to use any Unix-based tool to search-and-replace a > specific value which includes a tab character (e.g. replace "{TAB}7 > 00:00:00" with ""