friendVU admin <[EMAIL PROTECTED]> writes:
> When I execute this:
> "insert into comments
> (
> date_posted
> )
> (select date_published
> from xyz
> )"
> I get :
> "ERROR: column "date_posted" is of type timestamp without time zone but
> expression is of type tex
Try removing the comma after varz
SELECT into varx, vary, varz,
colx, coly, colz, FROM
I've tried parens and various other things but no luck.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TI
The docs say:
The result of a SELECT command yielding multiple columns (but only one
row) can be assigned to a record variable, row-type variable, or list
of scalar variables. This is done by:
SELECT INTO target select_expressions FROM ...;
where target can be a record variable, a row variab
maybe somthing like this:
CREATE OR REPLACE FUNCTION calendar (DATE, DATE) RETURNS SETOF DATE
LANGUAGE 'plpgsql' AS '
DECLARE
v_from ALIAS FOR $1;
v_to ALIAS FOR $2;
v_current DATE DEFAULT v_from;
BEGIN
WHILE (v_current<=v_to) LOOP
RETURN NEXT v_current;
v_curr
On Jan 28, 2005, at 23:55, friendVU admin wrote:
When I execute this:
"insert into comments
(
date_posted
)
(select date_published
from xyz
)"
I get :
"ERROR: column "date_posted" is of type timestamp without time zone
but expression is of type text
HINT: You will need to
When I execute this:
"insert into comments
(
date_posted
)
(select date_published
from xyz
)"
I get :
"ERROR: column "date_posted" is of type timestamp without time zone but
expression is of type text
HINT: You will need to rewrite or cast the expression."
Both dates a
Dear All,
How to create Calendar Function or Query. I would
like to display date form -mm-dd to -mm-dd or display date in one
Month
e.g:
date 2005-01-01 2005-01-02 2005-01-03 2005-01-04 2005-01-05 2005-01-06 2005-01-07 2005-01-08 2005-01-09 2005-01-10 2005-01-11
Hello
I want to write a trigger on a table.
In the trigger I want to call Java method and pass some data from the
table(on which trigger is set) as parameters to this method.
Can I do this in postgreSQL and if yes how?
Example would be helpful :)
Thanks
Swati
--
" Darkest Hour Of The Night Com
Deepthi Darshan wrote:
Hi,
I have a database which has been set to encoding UTF-8.
I have a table in this database in which i store the details of all the
registered users. I am using PL/PGSQL and using one function i am entering the
values into the database. There is one column for entering the pa
Hi,
I have a database which has been set to encoding UTF-8.
I have a table in this database in which i store the details of all the
registered users. I am using PL/PGSQL and using one function i am entering the
values into the database. There is one column for entering the passwords of all
regist
10 matches
Mail list logo
