David BOURIAUD wrote:
>
> Hi the list !
> How can I make a test on a int2vector ? If I have a vector that contains
> (1, 2, 5, 9), how can I check these values incivicually ? Thanks by
> advance for your help.
I answer myself by posting another question... Is there a way to know
from the system t
consider this function:
CREATE FUNCTION "test" (integer) RETURNS text AS 'return "select * from testt
limit $_[o];";' LANGUAGE 'plperl';
how would i get it to just run the query instead of just return it as text
using plperl?
---(end of broadcast)
I am interested in a query where I can select all dates between two dates. I
figure I can build a table of all valid dates with a resonable range and
then select from that table, but I would like to use the power of sql to get
the work done without building a date table. Any ideas?
For example:
I
If I have table A, which contains a primary key,
and table B which inherits from A.
How can I Create a Foreign Key on table C that references A, but will
also pass if a record in inserted in to B.
for instance:
create table A
(
prim_key char(20) not null primary key
);
create table B
Hi,
I've decided to switch from mysql to postgresql as my database server. I
do mostly web programming (who doesnt these days?) with more than a 100
sites developed (using mysql).
I've read about postgresql and it's features (such as triggers, stored
procedures, views) and I'd
You must be logged in as the unix user postgres.
(Presuming /home/postgres/ is writable by postgres and
the file doesn't exist.)
Try doing
touch /home/postgres/junk.tgz
from the command line. It should also fail.
Troy
>
>
> Hi to list !
>
> while running psql as 'postgres' user, i exec
Judd Maltin <[EMAIL PROTECTED]> writes:
> I have a special application that considers a playday to be from 8am to
> 3pm the next morning. The system then does maintenance from 3am till 8am
> (if necessary).
8am is in the eye of the beholder. Why not run the system in a timezone
selected such th
Hi,
we strongly need to implement an audit trail as a prerequisite for
clinical trials, that is a functionality which records any change of any
data item in a database into one single table containing these events.
I found that one could use rules for this, but this would require one rule
for
Jeff,
> I am interested in a query where I can select all dates between two
> dates. I
> figure I can build a table of all valid dates with a resonable range
> and
> then select from that table, but I would like to use the power of sql
> to get
> the work done without building a date table. Any i
On Wed, 6 Jun 2001, Tom Lane wrote:
> Judd Maltin <[EMAIL PROTECTED]> writes:
> > I have a special application that considers a playday to be from 8am to
> > 3pm the next morning. The system then does maintenance from 3am till 8am
> > (if necessary).
>
> 8am is in the eye of the beholder. Why
On Sat, 2 Jun 2001, Mario Bittencourt wrote:
> Hi,
>
> I've decided to switch from mysql to postgresql as my database server. I
> do mostly web programming (who doesnt these days?) with more than a 100
> sites developed (using mysql).
>
> I've read about postgresql and it's fe
On Wed, 6 Jun 2001, Markus Wagner wrote:
> The problem is, how to get the names of all tables and their attributes? I
> looked into the system tables ("pg_*"), but there were many tables and
> many attributes for *my* tables, and I did not figure out how to
> distinguish my tables and my attr
On Wed, May 30, 2001 at 11:14:38PM +0530, Sharmad Naik wrote:
> hi,
> I wanted to know that does postgresql database support php-nuke
This is a php-nuke question. Head to their website and it should be
stated there somewhere.
-Roberto
--
+| http://fslc.usu.edu USU Free
> Author URL
> ---
> A http://www.xyz http://www.abc .com
> - -
> B http://www.def http://www.ijk http://www.rst .com
> - -
>
> If that is what you want, you cannot manage it.
Sure, in no way this is possible with SQL (in
On Sat, Jun 02, 2001 at 06:49:55PM -0400, Mario Bittencourt wrote:
> Hi,
>
> I've decided to switch from mysql to postgresql as my database server.
Good for you :)
> procedures, views) and I'd like to know if there is some tutorial/snippet
> of code regarding such features spec
Hi,
I recently wipe my database away. And some of the tables have a UPDATE
CASCADE on it to another table.
When I reload the data from my backup that I did with pg_dumpall. My
code started to give me an error because I tried to modify a table that
was reference from another table. But the re
On Wed, 6 Jun 2001, Linh Luong wrote:
> I recently wipe my database away. And some of the tables have a UPDATE
> CASCADE on it to another table.
> When I reload the data from my backup that I did with pg_dumpall. My
> code started to give me an error because I tried to modify a table that
> w
Hello all,
I use postgresql as backend and MsAccess97 as
frontend via ODBC.
I know, how to use VBA and pass through queries to
update or insert rows in postgresql-tables.
But I don't know, how to do this the other way
round, from postgresql to MsAccess.
I want to develop a trigger, which u
Title: Functions and Triggers
I need help on creating a sql function that will check four rows in a table based on that check it will update another row on a different table. I want to use this function in a trigger statement.
Table 1 (Test Type)
id cat sub-cat test stat
Hello,
I'm a long time Postgres user who uses MySQL when I have to. I recently
ran into an issue with MySQL where this construct didn't do what I expect:
WHERE date_column = NULL
I expected it to work like "date_column IS NULL" like it does it
Postgres 7.0.2, but instead it returned an empty r
On Wed, 6 Jun 2001, Mark Stosberg wrote:
>
> Hello,
>
> I'm a long time Postgres user who uses MySQL when I have to. I recently
> ran into an issue with MySQL where this construct didn't do what I expect:
>
> WHERE date_column = NULL
>
> I expected it to work like "date_column IS NULL" like i
21 matches
Mail list logo
