Re: [SQL] TCL updates

Kyle wrote: > Jan wrote: > > Beginning with Tcl 8.0, dual ported objects got used to deal > >with values. These have (amongst performance issues) alot of > >benefits. Changing all the call interfaces would make it > >impossible to use PL/Tcl with a pre 8.0 Tcl installation

[SQL] [Fwd: inserting integer in Table]

> > In PostgreSQL table is : > > test=> \d test_blob_s; > Table= test_blob_s > +--+--+---+ > | Field | Type| > Length| > +--+

[SQL] Views on Unions

under 6.5.3 I see that I cannot do Views on Unions. Is this still true? This seems odd since a UNION should be a an R_Table Also it seems that I could not do a SELECT INTO or CREATE TABLE AS with a union (I get an error at union). Is there a syntax (i.e. using ()'s) that will work? -- Zo

[SQL] RULES on PostgreSQL

Hello all, Forgive my ignorance. I'm trying to understand the RULES in PostgreSQL and I have several questions. Why the rules if they are not part of SQL92 or SQL3? Where do they come from? Are they from before the SQL history of Postgres? Many things that can be done with RULES can be done with

Re: [SQL] password encryption

I think what he was looking for was more along the lines of a generic sql function that hashes a string, and not to update the system tables. I actually wrote a replacement for the mysql PASSWORD() function that is actually compatible with the hashing that mysql uses. If you would like a copy of

Re: [SQL] Select by priority again

"D'Arcy J.M. Cain" wrote: > [Note: PHP mailing list removed from Cc as this is strictly a > PostgreSQL question I think.] > > Thus spake Bernie Huang > > Sorry about this, but I don't quite get previous postings regarding > > select by prioriry. > > > > I have the same question with m

Re: [SQL] Select by priority again

[Note: PHP mailing list removed from Cc as this is strictly a PostgreSQL question I think.] Thus spake Bernie Huang > Sorry about this, but I don't quite get previous postings regarding > select by prioriry. > > I have the same question with my sql. I want to be able to select > cell

[SQL] Select by priority again

Sorry about this, but I don't quite get previous postings regarding select by prioriry. I have the same question with my sql. I want to be able to select cell_phone if there is one in the table; otherwise, I will select work_phone. table -- id, name, address, cell_phone, work_phone,... and

[SQL] TCL updates

Jan wrote: > Beginning with Tcl 8.0, dual ported objects got used to deal >with values. These have (amongst performance issues) alot of >benefits. Changing all the call interfaces would make it >impossible to use PL/Tcl with a pre 8.0 Tcl installation. >Since we're n

[SQL] altering column constraints

Is it possible to alter a column check constraint without a dump/reload? Now that I have RI working, it is a little more tricky to dump/reload a single table because you lose reference triggers. So I'm not sure how to change a column constraint without dumping/reloading the entire database. I l