dbTalk Databases Forums  

Sponsored Links

mailing.database.pgsql-sql mailing.database.pgsql-sql

Discuss in the mailing.database.pgsql-sql forum.

Post New Thread
Threads in Forum : mailing.database.pgsql-sql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hello, Postgresql8.3, tried: create table test(id, image oid); insert into test values(1, lo_import('apple.jpg')); ERROR: must be superuser to...
Emi Lu
05-18-2011 09:02 PM
Craig Ringer Go to last post
1 18
I have the following tables (individual seat allocation removed to make it simpler) create table coaches ( -- carriages c_id serial...
Gary Stainburn
05-18-2011 07:09 PM
David W Noon Go to last post
1 24
Hi, This probably reflects my confusion with how self joins work. Suppose we have this table: =# SELECT * FROM tmp; a | b ---+--- 1 | 2
05-17-2011 04:07 AM
Jasen Betts Go to last post
6 32
Hi, I am looking for a way to sort data returned from two tables with the first sort based on a field from table A and the secord sort based on the...
R. Smith
05-14-2011 07:58 AM
Oliver d'Azevedo Christina Go to last post
1 29
Hi all, I have this table id | date | score_count ----+--------------+------------- 13 | 1999-09-16 | 4 13 | 2002-06-27 | ...
Nguyen,Diep T
05-12-2011 05:18 PM
Samuel Gendler Go to last post
2 36
We are converting from Oracle to Postgres. An Oracle script contains this line: select replace(firstname,'"'), memberid, emailaddress from...
Tony Capobianco
05-11-2011 03:53 PM
Lew Go to last post
6 26
Hi, Maybe this is a dumb question but if I have a date field that contains a NULL will it show up when I ask for a where date range for the same date...
John Fabiani
05-10-2011 12:55 PM
Lew Go to last post
9 29
Hi there I am trying to get an example of SET BASED trigger logic with FOR EACH STATEMENT, but I cannot find any example involving the pseudo table...
05-09-2011 05:18 AM
Pavel Stehule Go to last post
2 24
Hi, When working with psql via sql.el, multiple prompts accumulate in a single line when sending multi-line input to the SQLi buffer. For example,...
05-07-2011 05:33 PM
Seb Go to last post
4 31
Hi, I'm playing around with 9.1beta1 and would like to create a table where one column has a non-default collation. But whatever I try, I can't...
Thomas Kellerer
05-07-2011 03:12 PM
Thomas Kellerer Go to last post
4 19
On Thu, May 5, 2011 at 11:06 PM, Tarlika Elisabeth Schmitz <postgresql3 (AT) numerixtechnology (DOT) de> wrote: You need another level of...
Scott Marlowe
05-07-2011 07:52 AM
Lew Go to last post
1 25
I have got a database that needs to be populated, first with historical data, then on a daily basis. Number of entities is small, data volume huge....
Tarlika Elisabeth Schmitz
05-07-2011 04:39 AM
Tarlika Elisabeth Schmitz Go to last post
3 35
Excuse me, The original table is: order*** ID*** value*** ---------------------- 1*** 1000*** 3 2*** 1000*** 5 3*** 1000*** 6 1*** 1001*** 1 2***...
Claudio Adriano Guarracino
05-06-2011 12:41 AM
Claudio Adriano Guarracino Go to last post
2 24
Hello! I have a doubt about a query that I tried to do, but I cant...... This is the scenario: I have a table, with this rows: order*** ID***...
Claudio Adriano Guarracino
05-05-2011 03:24 PM
Oliveiros Go to last post
1 26
Hello, ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get row_number select row_number(), col1, col2... FROM ...
Emi Lu
05-04-2011 12:28 AM
Andreas Kretschmer Go to last post
4 23
I know that BIT and BIT VARYING types were deleted from SQL:2003 and there are "old new" BINARY, BINARY VARYING in SQL:2008. I have two question: 1)...
Grzegorz Szpetkowski
05-03-2011 07:41 AM
Grzegorz Szpetkowski Go to last post
2 39
Hello everybody ! I want to know if I could share PLpgSQL variables between different functions and within different calls just using memory (not...
Charles N. Charotti
05-03-2011 06:01 AM
Viktor Bojović Go to last post
3 19
On 2011-04-15, LaraK <indarija (AT) gmx (DOT) net> wrote: if I undestand your goal correctly you want to subtract the daylight savings offset from...
Jasen Betts
05-03-2011 02:15 AM
LaraK Go to last post
3 25
Good morning !! How can I solve this problem : FATAL: invalid cache id: 19 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system...
manuel antonio ochoa
05-02-2011 11:25 AM
Tom Lane Go to last post
1 23
Hi. I just tried to make a query that traverses a tree upwards to locate the root and then downwards to locate all branches on PGSQL 9.0. The two...
Svenne Krap
05-01-2011 10:18 PM
Svenne Krap Go to last post
2 28
Hi guys, I need your help. I have a table called medidas, in this table i have some ocurrences that has id_medida(primary key) id_ponto (sec_key) and...
Saulo Venâncio
04-21-2011 06:15 PM
Jasen Betts Go to last post
2 22
Hello, i'm using a pl/sql procedure and I prevent inserting duplicate tuples using an exception for example: BEGIN INSERT INTO "Triples"(id,...
f vf
04-16-2011 07:13 AM
Jasen Betts Go to last post
3 20
I have the following query: select seta.store_id, avg(seta.sales) avg_seta, avg(setb.sales) avg_setb from (select store_id, avg(sales) sales from...
Anish Kejariwal
04-13-2011 02:03 PM
Anish Kejariwal Go to last post
3 22
Hi, I need to sum up the elements of two arrays. Most arrays were of the same size, thus I just unnested the arrays in one table and grouped the...
Andreas Gaab
04-13-2011 09:52 AM
Tom Lane Go to last post
1 22
SQL gurus, I have a table with 4 columns: lid(varchar), value(float), obstime(datetime), event_id(integer) I want to find the MAX(value) and the...
Mark Fenbers
04-08-2011 05:21 AM
msi77 Go to last post
2 28
Hi, I would like to have a simple way to retrieve information for a field name. By that I mean have some SQL select that will return all the tables a...
John Fabiani
04-05-2011 09:58 AM
John Fabiani Go to last post
3 28
How can i convert bigint to date format. bigint=616962528000000000
03-27-2011 03:32 AM
Jasen Betts Go to last post
3 25
while listing data types i have noticed that some types have underscore prefix but i don't know why is that. so im asking if somene can tell...
Viktor Bojović
03-24-2011 01:49 AM
Viktor Bojović Go to last post
2 22
Hi everyone! I recently noticed obscure behavior of ORDER BY. Consider this example: select email from ( select '@'::text as email union all select...
Tambet Matiisen
03-23-2011 03:09 PM
Pavel Stehule Go to last post
1 26
I'm confused by the deprecation notice on xml2 seen here <http://www.postgresql.org/docs/9.0/interactive/xml2.html>. What if anything was removed in...
Rob Sargent
03-23-2011 12:56 PM
Serdar Gül Go to last post
3 22
Hi Guys, I have the following table: Name Value rang salary ------------------------------------ name1 value1 1 2500 name2 value2 2 ...
Eric Ndengang
03-17-2011 11:12 AM
Richard Albright Go to last post
2 22
Hi, I'm trying to run an execute with a dynamic sql command within a function. I need a clean exception handling here, but my version does not...
Uwe Bartels
03-10-2011 12:38 PM
Uwe Bartels Go to last post
8 23
Hello pgsql community, Is there any string function (other than regex / scan & compare loop) to obtain a list (or even a count) of characters within...
Piotr Czekalski
03-07-2011 04:08 PM
bricklen Go to last post
1 13
This question is particularly geared towards self-joins, but can apply to any join where the tables involved have any identical column names. Aside...
03-02-2011 08:24 AM
S G Go to last post
7 18
When I install my application, I use a SQL script to create the different tables. Most of my tables start with a Serial column called RowId. In my...
Jacques Lebrun
03-01-2011 02:29 PM
Richard Huxton Go to last post
2 17
This error is returned Erro de SQL: ERROR: column "Aguardando Pagto" does not exist at character 352 >>> create or replace function...
03-01-2011 01:56 AM
Vibhor Kumar Go to last post
4 23
How Can I do to compare two structures of data bases ? DBA != DBB I need wich functions and wich tables are not equals thnks
manuel antonio ochoa
02-24-2011 04:51 PM
Isaac Dover Go to last post
5 27
I have the following function that I used in MSSQL. I would like to create the same function in PostgreSql. I think I am a bit confused on how to...
Ozer, Pam
02-23-2011 06:17 PM
Ozer, Pam Go to last post
1 22
Hi, I would have thought that there would be a simple built-in function that would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did...
John Fabiani
02-23-2011 01:11 PM
Emi Lu Go to last post
3 20
Hi, I tried to order a text-column only by parts of the entries. Therefore I used regexp_matches(), but unfortunately I am loosing rows. SELECT...
Andreas Gaab
02-22-2011 10:39 AM
Tom Lane Go to last post
1 20
Hi, Is it possible to get DISTINCT rows from an UPDATE statement using RETURNING clause? "MYTABLE" columns...
02-21-2011 05:50 AM
Gnanakumar Go to last post
3 17
Hello, I've got the following function and I want to access the fields values of my record by index. The problem is that my select is retrieving...
02-19-2011 03:47 AM
Dmitriy Igrishin Go to last post
3 19
Hi all! I am working on a query to identify which group ids exists within a spatial cell. In this case i have the GREG table which has polygon data...
Andreas Forø Tollefsen
02-17-2011 04:54 PM
bricklen Go to last post
3 15
Hi. If I have after insert trigger on some table which updates some data in that same table, will be the select statement from some other...
Rok Jaklič
02-17-2011 10:37 AM
Igor Neyman Go to last post
3 23
Pavel Stehule, 16.02.2011 11:50: Unfortunately they are not the same: Oracle does not support INFORMATION_SCHEMA Regards Thomas -- Sent via...
Thomas Kellerer
02-16-2011 11:28 AM
bricklen Go to last post
4 24
I'm altering datatypes in several tables from numeric to integer. In doing so, I get the following error: dw=# \d uniq_hits Table...
Tony Capobianco
02-15-2011 05:32 PM
Jasen Betts Go to last post
6 18
As you all know, when you specify an alias for a table or column name, the keyword "AS" is usually optional. I personally like to always include the...
Dean Gibson
02-15-2011 01:41 AM
Achilleas Mantzios Go to last post
1 27
Hi Everyone, I am trying to import some data (provided to us from an external source) from a CSV file using "\copy ...." But I get the following...
Gavin Beau Baumanis
02-13-2011 05:08 AM
Gavin Beau Baumanis Go to last post
3 18
Hi I'm trying to do a DELETE FROM on my large table (about 800 million rows) based on the contents of another, moderately large table (about 110...
02-12-2011 02:09 AM
Jasen Betts Go to last post
7 18
Hi, I'm just drawing a blank entirely today and would appreciate some help on this. The long and short; there are 12 distinct activities that need...
Aaron Burnett
02-11-2011 06:55 PM
Samuel Gendler Go to last post
6 20
Post New Thread

Display Options
Showing threads 451 to 500 of 3142
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.