-University of California at Berkeley
> 2232 Piedmont Avenue #2120 -Berkeley, California, 94720-2120 USA
> http://demog.berkeley.edu/~aperrin --SEIU1199
>
> On Wed, 3 Nov 1999, Simon Drabble wrote:
>
> > Ok, following on from the previous stuff, I&
-
> Aaron J. Seigo
> Sys Admin
Ok, thanks, I must admit I wasn't really aware of pl/pgsql, so this gives me a
reason to look into it.
Simon.
>
--
"Linux - open doors, not windows."
Simon Drabble It's like karma for your brain.
[EMAIL PROTECTED]
d be the parameter passed to the function:
SELECT fn_fubar(20);
Simon
Buying a SQL book this weekend :)
--
"Linux - open doors, not windows."
Simon Drabble It's like karma for your brain.
[EMAIL PROTECTED]
ld someone help me to understand this please?
>
> Regards,
> Chai
17681: oid (object ID) of the inserted row
1: number of rows inserted.
Simon.
--
"Linux - open doors, not windows."
Simon Drabble It's like karma for your brain.
[EMAIL PROTECTED]
The postmaster will croak if that file exists
> when it tries to start again. Hmm.
>
> -=Fozz
>
> --
> Doran L. Barton <[EMAIL PROTECTED]>
would this not be better?
while :
do
test -e /tmp/.s.PGSQL.5432 && rm /tmp/.s.PGSQL.5432
postmaster >> post.out
nce you have done this, you can add powner as a postgres user and assign
rights as necessary. the postgres super-user should really be only used to
start/ stop the back-end, and create new users (i.e. admin tasks). Use powner
to create databases and work with them.
Simon.
--
"This message
ar.
Simon.
--
"Don't anthropomorphise computers - they don't like it."
Simon Drabble It's like karma for your brain.
[EMAIL PROTECTED]
Got me an office; I'm there late at night.
Standard(?) SQL method is to use -- , e.g.
CREATE TABLE foo (
bar int,-- an integer
baz text-- some text
);
Simon.
--
"Don't anthropomorphise computers - they don't like it."
Simon Drabb
umn) VALUES ('Some ''quoted'' text');
Simon.
--
"Half-dead cat found in box -- Animal Rights group seeks Austrian scientist"
Simon Drabble Somewhere in cyberspace
[EMAIL PROTECTED]
On Mon, 24 May 1999, Simon Drabble wrote:
> On Mon, 24 May 1999, Anna Langer wrote:
>
> > When we created the table in the database we set the attribut to int4.
> > We get the problem when we trying to move the interger to the database.
> >
> > int a=500;
>
ration shut the system down. Evidently,
the software identified Windows NT itself as a virus and disabled it.
-- http://www.vcnet.com/bmc/departments/nt/bugs.shtml
Simon Drabble Somewhere in cyberspace
[EMAIL PROTECTED]
ent.
Is there a quick way to retrieve these rows?
Simon.
--
Caveat lector
Simon Drabble Somewhere in cyberspace
[EMAIL PROTECTED]
there was no scroll bar in that frame. (I take it that's a frame down
thar). In fact some of the menu items were barely visible at all. :(
Si.
--
"The real reason Heisenberg and Schrodinger didn't get along is because,
unknown to many historians, Heisenberg had a dog."
Simon Drabble Somewhere in cyberspace
should come with an `Undo' button."
Simon Drabble [EMAIL PROTECTED]
I'm looking for a really good book on SQL (not Postgres particularly) to
include such arcanery as
Triggers
Stored procedures
Query optimisation
Examples illustrating these concepts will be a big bonus.
Any recommendations?
Si.
--
Simon Drabble [EMAIL PROTECTED]
the members database is not created.
> >
> > Apart from separating out all the data (COPY blocks) from the command
> > lines, and running two or more separate routines to update the data, is
> > there anything I can do?
> >
> >
> > Si.
> >
>
tes * Web Developer * http://www.valeriemates.com
>[EMAIL PROTECTED] * (734) 995-6716
> ---
>
>
>
--
There are three kinds of people in this world: Those who can count,
and those who can't.
Simon Drabble mailto:[EMAIL PROTECTED]
ht
17 matches
Mail list logo
