s far as I can tell the to_char()
> function is not overloaded for the time type just timestamp.
>
> How do I format a column of type time to HH:MM AM | PM ?
> I belive the now() function returns a timestamp. but I need a strict time
> datatype example.
>
> Thanks again
> Jef
ch of transactions?
--
Robert B. Easter [EMAIL PROTECTED] -
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
-- http://www.comptechnews.com/~reaster/
On Sunday 07 January 2001 13:13, Tom Lane wrote:
> "Robert B. Easter" <[EMAIL PROTECTED]> writes:
> > UNION JOIN is deprecated
>
> Oh? By whom?
>
> The reason 7.1 doesn't have it is I didn't have time for it, not that
> we don't plan to d
On Sunday 07 January 2001 00:53, Robert B. Easter wrote:
> Union join:
> T1 UNION JOIN T2
>
> is not implemented. Nice! :)
[snip]
> SELECT * FROM a UNION JOIN b;
>
> ERROR: UNION JOIN is not implemented yet
> psql:/home/reaster/sql/join/join.sql:37: ERROR: UNION JOIN
On Saturday 06 January 2001 20:21, Tom Lane wrote:
> "Robert B. Easter" <[EMAIL PROTECTED]> writes:
> > What is the syntax for this? Is there an example I can see/run?
>
> SQL92 standard.
>
> See
> http://www.postgresql.org/devel-corner/docs/postgres/sql
a
> [EMAIL PROTECTED]
--
Robert B. Easter [EMAIL PROTECTED] -
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
-- http://www.comptechnews.com/~reaster/
hly inefficient
> > simulating outer joins with subqueries and UNION ALL statements. Or,
> > perhaps PostgreSQL has another way prevent unjoined rows from being
> > supressed in the results. Your comments are welcome.
> >
> > Thanks, Micael Dunn
--
Robert B
em since the constraints require
> that the other table exists.
> If doing the above is *not* a Bad Idea, how could I work around this
> problem?
> (That is, (how) can I add the constraints after table creation?
> I imagine something with "create constraint trigger", but the
On Wednesday 27 December 2000 15:09, Mike Castle wrote:
> On Wed, Dec 27, 2000 at 01:40:09PM -0500, Robert B. Easter wrote:
> Just think if you have to move all users from one version to another. You
> would prefer to edit each person's .profile rather than one central one?
When
ny help on this problem would
> be greatly appreciated.
>
> Thank you for your time,
> ch
--
Robert B. Easter [EMAIL PROTECTED] -
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
-- http://www.comptechnews.com/~reaster/
On Thursday 14 December 2000 21:10, Robert B. Easter wrote:
> On Thursday 14 December 2000 21:27, Dan Wilson wrote:
> > I'm totally fine up to this point... then I try this:
> >
> > UPDATE help SET site_id = 'APW' WHERE help_id = 2;
> >
> > I g
near line 1
> "RROR: parse error at or near "
Try:
UPDATE help SET site_id = ''APW'' WHERE help_id = 2;
Remember that ' is used to enclose the whole function body. You have to use
'' to mean a literal '.
--
Robert B. Ea
On Thursday 14 December 2000 18:54, Robert B. Easter wrote:
> Trigger functions, no matter what language, have be RETURNS OPAQUE.
>
> Here is an example (in the PostgreSQL docs):
> http://www.comptechnews.com/~reaster/postgres/triggers20290.htm
>
> Sorry I can't help more
the
> "RETURNS" clause?
>
>
> One more question,
> If a trigger does not succeed then I want to ABORT transaction, is
> it possible? how?
>
>
> - Sandeep
--
Robert B. Easter [EMAIL PROTECTED] -
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
-- http://www.comptechnews.com/~reaster/
On Wednesday 13 December 2000 17:45, Matt Beauregard wrote:
> On Wed, Dec 13, 2000 at 05:30:49PM -0500, Robert B. Easter wrote:
> > On Wednesday 13 December 2000 17:04, Robert B. Easter wrote:
> > > Has anyone experienced referential integrity (RI) problems while
> > >
On Wednesday 13 December 2000 17:04, Robert B. Easter wrote:
> Has anyone experienced referential integrity (RI) problems while restoring
> data from a dump? Like, if the dump doesn't restore the data in the right
> order, then primary keys might not be in place before the fo
L/SQL triggers myself.
--
Robert B. Easter [EMAIL PROTECTED] -
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
-- http://www.comptechnews.com/~reaster/
t;select surname, firstname, title, company, worktel, ext, hometel,
mobile, email, emailtwo from employees where firstname ~* '{$criteria}'
or surname ~* '{$criteria}'";
See Bruce Momjian's book:
LIKE expressions:
http://www.postgresql.org/docs/aw_pgsql_book/node51.
gh, but
> now, I need to increase the site of the column. How can I do that?
> Thanks,
>
> Joe
You can dump the database to file.sql, edit file.sql and change the size of
the column, save it, drop the database, and reload it from file.sql.
--
Robert B. Easter [EMAIL PROTECT
On Sat, 29 Jul 2000, [EMAIL PROTECTED] wrote:
> Dear all,
>
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different page.
>
> Many
On Sat, 29 Jul 2000, [EMAIL PROTECTED] wrote:
> Dear all,
>
> I need drawing tools to show the table relationship. I have used pgaccess but
> it seems that the effect is not very good. Are there any recommendations?
Dia
http://www.lysator.liu.se/~alla/dia/
--
- Robe
On Wed, 12 Jul 2000, Scott Holmes wrote:
> I'm afraid I just don't see how this is done without being able to pass
> arguments to the procedure or actually running an additional SQL statement
> within the trigger:
>
> I have a "notes" table that is potentially linked to records in many othe
I'd like to know what hardware and software people use to perform tape backup
of an online database on Linux. I would imagine the following might work(?):
1. Use RAID mirroring of the disk the db is on onto 2 two or more other
disks.
2. When it is time to do the backup, disconnect one
'DDD');
See the documentation at:
http://www.comptechnews.com/~reaster/postgres/functions2976.htm
--
Robert B. Easter
(new_seq);
INSERT INTO test2 VALUES (new_seq);
RETURN new_seq;
END;
' LANGUAGE 'plpgsql';
-- implicit BEGIN;
SELECT new_tests();
-- implicit COMMIT;
SELECT new_tests();
SELECT new_tests();
SELECT * FROM test1;
SELECT * FROM test2;
DELETE FROM test1 WHERE id = 1; -- this will fail
DELETE FROM test2 WHERE id = 1; -- this will succeed and cacade
SELECT * FROM test1;
SELECT * FROM test2;
--
Robert B. Easter
ing in docs.
>
> Any suggestions.
pg_dump/all do not dump the large objects (AFAIK).
ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.4.tar.gz
might help you
--
Robert B. Easter
[EMAIL PROTECTED]
ou to use the file
> "postgresql-v6.4.tar.gz", which I haven't got on my computer.
>
> I also tried to run the following command:
> $initdb
> but it cannot work yet.
>
> Someone told me I should establish a data store for the PostgreSQL. What's
> that? How to?
>
> Do I need to download "postgresql-v6.4.tar.gz" to re-install the PostgreSQL?
> Or how can I
> solve my problem? What's in the earth wrong? What's indeed the PGDATA mean?
>
> Any suggestion or hints are appreciated greatly!
>
> With my best regard:
> Janet
--
Robert B. Easter
[EMAIL PROTECTED]
In this
case, it would only look down into the tree to 3 levels below supertable and
you'd never get row-types that are down lower than level 3. Anyhow, I still
don't think returning multple row-types is going to happen, not that I have any
authority one way or the other! :-)
--
Robert B. Easter
[EMAIL PROTECTED]
If I set the block size from 8k to 16k by editing /include/config.h, then all
tuples will take up 16k on disk? If true, it just wastes lots of disk space if
you are really not going to be storing more than 8k in most tuples?
--
Robert B. Easter
[EMAIL PROTECTED]
been said that Postgres can use up to 32k per tuple. Is the max kb per
tuple equal to the block size of the filesystem? That is, if I want 32k max
tuple size, I have to put Postgres on a filesystem that is using 32k blocks
(or 16k??) ?
I'm confused! :)
--
Robert B. Easter
[EMAIL PROTECTED]
In the pgsql-hackers list, its been stated that SSL can be used on the
client/backend connection. Where is this documented if I want to try it?
Or, can anyone just tell me know?
--
Robert B. Easter
[EMAIL PROTECTED]
On Mon, 08 May 2000, Andrzej Mazurkiewicz wrote:
> Try:
>
> http://www.htc.honeywell.com/DoME
>
> It is not strictly ERD but a VERY reasonable CASE with above other things
> Coad-Yourdon OOA that can be easily extended to ERD denotations. The best
> choice (because of licencing) is precompiled v
Does anyone know of any good package for Linux for assisting with database
design? I'd like to find a program that can be used to create/manipulate
entity-relationship diagrams. It would be nice bonus if one could also output
the postgresql sql schemas from it.
--
Robert B. Easter
[
My understanding is that what you get from crypt(pw, salt) =
$1$$
Please correct me if I wrong. Again, not an expert.
On Sun, 07 May 2000, you wrote:
> "Robert B. Easter" wrote:
> >
> > On Sun, 07 May 2000, Hannu Krosing wrote:
> > >
> > &g
On Tue, 02 May 2000, surfer girl wrote:
> Hi Robert,
>
> Thanks for the code. I tried the code, and it works fine (no errors) except instead
>of getting an image output, it outputs "/tmp/php08543baa" to the browser or something
>similar (just like my code). Am I missing something where I shoul
On Tue, 02 May 2000, Tom Cook wrote:
> On Tue, 2 May 2000, Peter Eisentraut wrote:
>
> > Anand Raman writes:
> >
> > > Is there anything equivalent to the enumerated data types in
> > > postgresql..
> >
> > You might find that strings with check constraints will do the job, e.g.
> >
> > create
x27;t
think there is a primary key on the system tables. I wonder if it would cause
problems if there where?
Anyway, does anyone know of a way to accomplish something like what I am trying
to do with the large objects?
--
Robert B. Easter
[EMAIL PROTECTED]
e as follows:
---
---
--
Robert B. Easter
[EMAIL PROTECTED]
don't
really - just unique is good enough. Again, I want to use what is simplest
but more importantly, that stands the best chance of not being corrupted
during backup/restore.
Any caveats or experiences anyone can share would be great!
Robert B. Easter
[EMAIL PROTECTED]
On Sun, 16 Apr 2000, you wrote:
> There are some programs out there to dump large objects and I've been playing
> with one. It's worked well so far. You can get it at
> ftp://ftp2.zf.jcu.cz/zakkr/pg/
>
> ---
>
> file not found...
Correction:
ftp://ftp2.zf.jcu.cz/users/zakkr/pg/
On Sun, 16 Apr 2000, Frank Joerdens wrote:
> A while ago it was being held that the Postgres large object data type
> was too new and not sufficiently tested and mature to be used in a
> production environment. I am about to deploy a little database that
> involves storing large-ish text files (20
41 matches
Mail list logo
