I have a table that has a 'date' column. In psql I tried to do a
select proofdate::text from openjobs where jobno = '10625';
responce: can not cast type 'date' to 'text'
Did i miss-read this section. I thought I could cast the date to text. has anyone seen
this or am I missreading the docs?
This is a rather generic question about "date" and "time". I seem to
be beating my head on the wall. I was trying to use a set up a table
with a 'date' and 'time' field. I wanted to keep the two separate.
Can someone explain if there is a difference between a time field
and a timestamp. I do
I am away from my server for the weekend and I need a little help.
when doing updates of multiple fields there commas between
the elements?
I mean
update table set cname = 'Bill', caddress = '2nd floor' where acode =
'AVAN';
I refer to the space between 'Bill' and caddress.
if I could g
Is there anywhere in the docs that says we should not use an
underscore in a table name?
table FC_Client_Info exists with a record where jobno 1234 has
info:
select acode from FC_Client_Info where jobno = '1234';
fails with a warning that fc_client_info does not exist
notice the lower case. I
I have a table that I want to add a serial type column. Is there a way
to add it or do I have to create a new table and insert into it. I have
experimented with:
insert into newdb (name) select name from olddb order by jobno;
however, pg does not allow the 'order by' during an insert/select
I
I have been working with PG for about 2 months now. I am creating a
job tracking system for my company. I have written a front end on the
workstations (all macintoshes) that seems to be working quite well.
However, I have a problem with a concept.
In my current setup I have only one workstati
that people with more expierence might
shed a little light here.
Thanks for your time.
Ted
-Original Message-
From: Jan Wieck <[EMAIL PROTECTED]>
To: postgresql <[EMAIL PROTECTED]>
Date: Thu, 22 Mar 2001 14:48:19 -0500 (EST)
Subject: Re: [SQL] creating "job numbers&q
e accounted for as used or null. But it should not skip.
Thanks,
Ted
-Original Message-----
From: Michael Ansley
<[EMAIL PROTECTED]>
To: 'postgresql' <[EMAIL PROTECTED]>
Date: Fri, 23 Mar 2001 13:22:09 -
Subject: RE: [SQL] creating "job numbers"
>
How does currval work if you are not inside a transaction. I have
been experimenting with inserting into a table that has a sequence.
If the insert fails (not using a transaction) because of bad client input
then the next insert gets the proper next number in the sequence.
given sequence 1,2,3
n
passing it back to my app. commit, then do an update. I can not
seem to get the seq to work.
Ted
-Original Message-
From: Michael Fork <[EMAIL PROTECTED]>
To: postgresql <[EMAIL PROTECTED]>
Date: Thu, 29 Mar 2001 10:04:46 -0500 (EST)
Subject: Re: [SQL] serial type; race co
I guess the subject line says ithas anyone tried running
PostgreSQL in MAC OS X.
I see that in the product brochure, Apple specifically mentions Mysql.
I run a shop that has all mac computers. I am runnng just 1 linux box
(SUSE Linux on a Max G3) to run the job tracking system.
Please
I have started my pg installation using port 5444 (with the -p 5444
switch). Everything is working fine inside my installation with the
internal ip number (a 192.168 number). I created a tunnel in my
firewall to point to the linux box running pg with the port 5444 open. I
can not seem to get t
Hi,
I have a table of categories (it's pseudo-sql...) :
CATEGORIES
(
id_category PRIMARY KEY,
id_category_parent (FOREIGN KEY ? CONSTRAINT ??) ,
cat_text
)
There is recursivity : id_category_parent is -1 (= no parent cat) or the
id_category of a category in this table.
What is the S
Hi,
How to create a foreign key in postgresql ?
need triggers ?
Thanks,
Fred
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
gsql';
All is ok at creation.
But now , how can i use my function ? i would like a thing like :
SELECT tester(14) AS ok;
But is make a Postgresql parser error
How to do then ??
Thanks for any help or links (other than the postgresql.org website...) !
;)
Regards,
Fred
-
Is there a way to return the current oid of a transaction?
I am trying to:
begin;
insert into db something;
select current session oid
commit;
I will only ever be inserting one row during the transaction.
Is this doable?
Thanks for your time.
Ted
---(end of broad
I am experimenting with running PG 7.1.2 on Mac OSX. I seem to
have a problem with getting my users to connect. This works
beautifully when connect to my linux box.
Any ideas?
[localhost:/etc] postgres% /usr/local/pgsql/bin/postmaster -i -p5444 -D
/users/postgres/pgdata
DEBUG: database sys
At times things seem just too easy, so I want to confirm that this is the
correct syntax.
I am looking for the interval (aging) for these invoices. I guess I am
concerned because I guessed at the syntax. Is there a better way to do
this?
billdate is type 'date'
SELECT ('now'-billdate) FROM f
27;, outer joins, left
joins. I get lost. Where can I get more info. I really want to
understand.
Thanks for your time. I guess it's back to the bookstore.
-Original Message-
From: "Joseph Syjuco" <[EMAIL PROTECTED]>
To: "postgresql" <[EMAIL PROT
CREATE TABLE tablename (colname SERIAL);
okay, but how do I set the beginning number. So far the only thing I
have been able to do is directly after creating the serial column, I do:
select setval('tablename_colname_seq', 15753);
Is this the only way to set the beginning number of a sequence?
out why I would EVER want one. Which leads me to think that I
just don't understand them.
Please, if someone has a good example..
Ted
[EMAIL PROTECTED]
-Original Message-
From: Francesco Casadei <[EMAIL PROTECTED]>
To: postgresql <[EMAIL PROTECTED]>
Date: Sat, 22 Sep
Where can I get more information and examples on using JOINs. I
have been reading over the Chapter 2 on from the interactive user
docs but I need a little more in the way of examples. I am having a
problem understanding when I would need a LEFT or RIGHT JOIN.
Please, a 'point' in the right
or must be used when
-twolevel_namespace is in effect
make[3]: *** [libpq.so.2.1] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
[localhost:/Users/postgres/postgresql-7.1.3] root# make -v
GNU Make version 3.79, by Richard Stallman and Roland McGrath.
Bui
HI!
I'm new to postgres. I need to have a table as a copy of another one.
Example:
CREATE TABLE one (
fileda INTEGER,
filedb INTEGER,
filedc INTEGER );
CREATE TABLE two (
fileda INTEGER,
filedb INTEGER,
filedc INTEGER );
As on insert to table o
I have been tring to use index on timestamps:
I have a table with a timestamp filed with index on it.
I nned to extract all the ids of the table with datarx
>= a date
<= a date
or between 2 dates
I found that the only way to force postgres to use index is:
explain select id,datarx::da
On postgres 7.2.3 I have found what follows:
explain select * from documents where iddoc>1;
Seq Scan on lotti (cost=0.00..831.79 rows=26783 width=98)
EXPLAIN
explain select * from documents where iddoc=1;
Index Scan using lotti_pkey on lotti (cost=0.00..2.26 rows=1 width=98)
Why index is n
Hi all,
first of all, let me explain what I'm trying to do.
I have a table with a fairly complicated trigger. In this trigger I
have a specific set of codelines that can be executed in more than 50
places that works on the new.* fields in order to fix/clean them.
In order to improve readability,
Sorry. I realize I slipped an error in my code:
the code is:
---
CREATE TABLE public.imp_test
(
id int8,
value text
) WITHOUT OIDS;
CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test)
RETURNS imp_test AS
'begin
return $1;
end;'
LANGUAGE 'plpgsql' ST
Ok. I think I found the problem is related to this Bug.
is there anywhere to check the status of this bug?
regards,
=
Riccardo G. Facchini
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I'm having this problem inserting data from my form using PL/pgSQL.
Here is the simplified version of my table and function (this example
does not work, also ):
CREATE TABLE theirry.sample (
staff_id serial PRIMARY KEY NOT NULL,
firstname varchar(100),
lastname varchar(150),
usern
Thanks for the catch. I've tried:
$connection->execute("SELECT
insert_staff_b('$staff[insert_firstname]'::varchar)");
$connection->execute("SELECT
insert_staff_b('".$staff['insert_firstname']."'::varchar)");
None work... I'm scratching my head on this one.
Thanks,
J
Tom Lane wrote:
PostgreSQL Admin <[EMAIL PROTECTED]> writes:
CREATE OR REPLACE FUNCTION insert_staff_b
(insert_firstname varchar)
RETURNS VOID AS
...
Still I get this error:
Warning: pg_query(): Query failed: ERROR: function
insert_staff_b(character varying) does not exist
Thanks,
The search path was the problem. Sometimes it's the simple things.
Big thanks,
J
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
I want to replace a title with dashes and also remove punctuation.
e.g, The blue fox's fur. -> The-blue-fox-fur
Thanks for any input,
J
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
su
test=*# select regexp_replace(regexp_replace('The blue fox\'s fur.', ' ', '-',
'g'), '\\.', '');
regexp_replace
The-blue-fox's-fur
(1 row)
Andreas
Thanks for the input.
I came up with this:
REPLACE(regexp_replace('The blue fox\'s fur', '[[:punct:]]', ''), ' ',
Hi,
This is seemly simple, but I'm @ a loss this early in the morning. It's
best explained this way
SAMPLE
---
id | serial|
username | varchar(100)| constraint username >=8 and username <=100
The problem is that it's characters not
As anyone used pgmemcache? I would like to look more into a but I'm
having problems installing the sql. I'm on OS X 10.4 and the sql there
are lines causing errors:
(e.g. AS '$libdir/pgmemcache', 'memcache_server_add' LANGUAGE 'C' STRICT;)
thanks for any input and also will version 1.2 come
I have a question that I've thought in my head about using triggers, but
I figure to ask people that do SQL more than I. So, I have a table that
I want two columns.
(1) A featured column which is for only 1 row, once it switched to
another row than all other rows must be false
title
> --- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
>
>> CREATE UNIQUE INDEX Only_one_row_true
>> ON Your_table ( featured )
>>WHERE featured = true;
>>
>> Or if you want to only allow 1 featured article per catagory then:
>>
>> CREATE UNIQUE INDEX Only_one_row_true_per_catag
I want to write a trigger that updates a different row on the same
table. It's pretty basic: before the any row in his table updated I
want to set a only row that has the value true to false. I keep getting
this error:
SQL statement "update theirry.articles set master_featured = false where
mast
chester c young wrote:
> how are you preventing recursion?
>
>
That could be the problem, suggestions?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
I have a table in which people will have a number of questions to
answer. I want those pk to be placed in my user table. So if a user
answers three question I want those 3 pk's in the user table (fk).
What should I be doing?
Thanks in advance,
J
---(end of broadcast)
This is my layout so far:
CREATE TABLE users (
id serial NOT NULL,
--question REFERENCES questions(id) ON DELETE CASCADE ## ON REMOVED##
);
CREATE TABLE questions (
id serial NOT NULL,
questions varchar(450) NOT NULL
);
CREATE TABLE answers (
id serial NOT NULL,
question_id int REFERENCES questi
No problems with the design - I was not thinking with the DB hat on at
first. I have been working on clustering for a while... just adjusting.
Thanks everyone.
:)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
We are using this bad piece of the software that does not close
connections to the postgres server. Is there some setting for closing
dead connections? And not TCP/IP keep alive does not work.
---(end of broadcast)---
TIP 4: Have you searched our
Simple question - but my brain is not working:
This is my table
Column | Type |
Modifiers
---++-
id| integer
I have a inventory system design in which I would like some help with to
see if it's efficient. The products are broken into:
Product tables
Property tables
Configurable Products - this would include colors (i.e. - black, blue
and green) tied to products
I'm thinking of breaking inventory in
I have a table like this:
usda=# \d nutrient_data
Table "public.nutrient_data"
Column | Type | Modifiers
-+---+---
ndb_no | integer | not null
nutrient_no | integer | not null
Steve Crawford wrote:
PostgreSQL Admin wrote:
I have a table ...
when I run this query:
select ndb_no, nutrient_no, nutrient_value from nutrient_data where
ndb_no = 13473;
it produces:
ndb_no | nutrient_no | nutrient_value
+-+
13473 | 203
Mark Roberts wrote:
On Wed, 2008-06-11 at 14:41 -0400, PostgreSQL Admin wrote:
I would like to have multiple values nutrient_no:
ndb_no | nutrient_no | nutrient_value
+-+
13473 | 203 | 24.18
13473 | 204 | 15.93
13473
this is a small sample of the data:
short_desc
| long_desc
--+---
Hi,
I have BOTH a sql AND db design question.
I'm creating a cookbook DB with have broken the table into this:
RECIPE TABLE
Column | Type | Modifiers
---+--+--
id | integer | not null default nextval('r
52 matches
Mail list logo
