Michael-
Nice explaination of what was happening to the temp
table.
Thank you.
-Chad
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Aug 08, 2006 at 10:24:02AM -0700, Chad
> Voelker wrote:
> > The Goal: Return a set of records from one table
> based
> > on entries in a temporary table. I
Tomski wrote:
> Hello!
> As many of you know, SQL Server (2000) has peculiar data type "timestamp"
> which is not SQL standard timestamp. In fact it is "rowversion" type. It
> makes tha field to be updated with current timestamp when row is updated or
> inserted.
> Is there any similiar functionali
I'm currently handling a migration from an Informix system to both mySQL
and Postgres (same data in each).
Having uploaded the DB's into both systems, from Informix, I am having
some problems carrying out a query. The query, which I believe, is in
standard SQL is as follows:
SELECT field1, SUM(fi
Hi all!
i run this query
select f1,f2
from t1,t2
where
t1.url_id=t2.entry_id and
(t1.entry_stamp::date>=(now()::date-interval '14 days')) and
the problem is that t1 is a very big table so the query is too slow.
what if i move the second condition to where-clause. Can this reduce the
select
Title: to_dec()
I have created a to_dec() function, which is in essence, the opposite of the to_hex() function.
Does anybody know how I can submit this function to Postgresql ?
Hi,
Is is possible to query from my application whether there is a primary
key or unique constraint on a given table and field name(s)?
Thanks
LL
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archive
Use Alter table notebook from control center
right click on the table and open alter table notebook
you can drop a column or add a column or change the datatype
Kumar
On 8/7/06, Judith <[EMAIL PROTECTED]> wrote:
Hello everybody, excuse me how can I change de data type of a field,I currently h
Hi ALL,
I want to do date arithmetic in SQL with a column that is integer.
example
create table bob (
col1 timestamp
, col2 int4
;
where col2 represents a number of minutes.
I want to do something like
select col1 + interval col2 minutes
from bob
This is doable with most other RDBM
chrisj escreveu:
Hi ALL,
I want to do date arithmetic in SQL with a column that is integer.
example
create table bob (
col1 timestamp
, col2 int4
;
where col2 represents a number of minutes.
I want to do something like
select col1 + interval col2 minutes
from bob
This is doable wi
> Is is possible to query from my application whether there is a primary
> key or unique constraint on a given table and field name(s)?
Curiously enough, I just answered a similar question on the pgsql-admin
list. Try this:
SELECT c.relname as table, r.conname as contraint_name, r.contype as
co
> Curiously enough, I just answered a similar question on the pgsql-admin
> list. Try this:
>
> SELECT c.relname as table, r.conname as contraint_name, r.contype as
> contraint_type, pg_catalog.pg_get_constraintdef(r.oid, true) as
> constraint_definition FROM pg_catalog.pg_constraint r,
> pg_cata
You can do the following:ALTER TABLE table-name ALTER colum-name TYPE text;Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 8/8/06, Kumar Dev <[EMAIL PROTECTED]> wrote:
Use Alter table notebook from control center
right click on the table and open alter table notebook
you can drop a colum
I have a table with a column, lets call it identifier, that is defined
as varchar(8) that should never contain lower case letters. Its a large
table. Is there a way to query the table to see if any values in this
column are lower case and to get a list out? The user interface
application tha
On 8/10/06, Juliann Meyer <[EMAIL PROTECTED]> wrote:
I have a table with a column, lets call it identifier, that is defined
as varchar(8) that should never contain lower case letters. Its a large
table. Is there a way to query the table to see if any values in this
column are lower case and to
On 8/10/06 4:32 PM, "Juliann Meyer" <[EMAIL PROTECTED]> wrote:
> I have a table with a column, lets call it identifier, that is defined
> as varchar(8) that should never contain lower case letters. Its a large
> table. Is there a way to query the table to see if any values in this
> column are l
On Thu, 2006-08-10 at 15:32, Juliann Meyer wrote:
> I have a table with a column, lets call it identifier, that is defined
> as varchar(8) that should never contain lower case letters. Its a large
> table. Is there a way to query the table to see if any values in this
> column are lower case a
Juliann Meyer wrote:
I have a table with a column, lets call it identifier, that is defined
as varchar(8) that should never contain lower case letters. Its a
large table. Is there a way to query the table to see if any values
in this column are lower case and to get a list out? The user
int
Hi Guys,
A fellow at work has written the SQL below to retrieve some data from
multiple tables. Obviously it is inefficient and unnecessarily complex, and
I am trying to break it into 2 or more queries so as to enhance performance.
Can you please help me do so? I would appreciate any help you can
On 4 aug 2006, at 08.55, Jonathan Sinclair wrote:
SELECT field1, SUM(field2) as Field2, SUM(field3)
FROM table1 tb1, table2 tb2
WHERE tb1.field5 BETWEEN '03/07/2006' AND '03/08/2006'
AND tb1.field6 = tb2.field7
AND tb1.field8 = tb2.field8
AND tb2.field9 BETWEEN 50.00 AND 150.00
GROUP BY field1
H
When I psql -f f.sql
I get the following error:
psql:f.sql:10: ERROR: relation "fragset" does not exist
CONTEXT: SQL function "fragments"
> cat f.sql
Create Or Replace Function fragments(character varying)
Returns setof character varying
As $$
Create Temporary Table fragset (smiles character
20 matches
Mail list logo
