| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have postgresql 9.1.3 on a mac and on linux.
On the mac the results come out:
! *`-=;',./~@#$%^&()_+{}|:"<>?\
then
\--\
Wes James
|
Yesterday 12:41 AM
Jasen Betts  | 13 | 38 |
| | | Good day.
I am quite new to Postgres, so please bear with me.
I have a table with data in the following format:
Elrich Marx
|
05-26-2012 12:43 AM
Raj Mathur | 5 | 10 |
| | | Is it possible to identify which inherited table data came from in a query?
We have a table that has 3 inherited tables attached to it. I am...
George Woodring
|
05-25-2012 08:40 AM
George Woodring | 3 | 4 |
| | | Hello. I hope you can help me with this or at least guide me into the right
direction:
I have 2 tables:
CREATE TABLE infos
(
id integer NOT NULL...
danycxxx
|
05-25-2012 07:57 AM
danycxxx | 2 | 3 |
| | | Hi.
I am building a system, where we have jobs that run at different times
(and takes widely different lengths of time).
Basically I have a jobs...
Svenne Krap
|
05-25-2012 07:52 AM
Jan Lentfer | 1 | 2 |
| | | Hello everyone! I wanted to ask the list a question about the 'bytea'
data type & how I can picture this in my head. I've been reading SQL
for about...
Carlos Mennens
|
05-24-2012 11:36 AM
F. BROUARD / SQLpro | 2 | 5 |
 | | Hi folks,
I know I've seen posts like this before but Google isn't helping today.
I have two tables, vehicle stock and tax requests. Each vehicle...
Gary Stainburn
|
05-24-2012 03:27 AM
Oliveiros d'Azevedo Cristina | 10 | 11 |
| | | Hi,
I like PostgreSQL for many reasons, one of them is the possibility to
use sub query everywhere. Now I've found where it doesn't support them.
I...
Ferruccio Zamuner
|
05-24-2012 02:07 AM
Samuel Gendler | 2 | 3 |
| | | Hi,
suppose a table that has records with some ID and a timestamp.
id, ts
3, 2012/01/03
5, 2012/01/05
7, 2012/01/07
3, 2012/02/03
3,...
Andreas
|
05-21-2012 04:17 PM
Seth Gordon | 1 | 5 |
| | | On Monday 21 May 2012, Jan Bakuwel wrote:
Something like this ought to do it (not tested):
select latest.price, latest.price -...
Raj Mathur
|
05-20-2012 11:34 PM
Andreas Kretschmer | 2 | 6 |
| | | Hi,
I'm trying to fight against double entries in tables.
I got as far as I can find similar records with trigram string matching.
If I do this with...
Andreas
|
05-20-2012 04:08 AM
Andreas | 2 | 14 |
| | | Try this
create view v(id) as select * from func(5);
if your function returns one column.
15.05.2012, 10:01, "Jan Bakuwel" <jan.bakuwel (AT)...
msi77
|
05-15-2012 07:21 AM
Misa Simic | 3 | 8 |
 | | I have a problem in SQL I don't know how to solve and while I'm sure
there are 100+ ways to do this in ANSI SQL, I'm trying to find the
most cleanest...
Carlos Mennens
|
05-15-2012 06:00 AM
Dmitriy Igrishin | 17 | 18 |
| | | I need to maintain a sync-ed table across several databases. For example I
have a customer table in 5 databases. If a user of any of the...
John Fabiani
|
05-14-2012 07:04 AM
Devrim GÜNDÜZ | 7 | 23 |
| | | Hi,
I am trying to create a daily backup cron script but it fails with an error
as below:
Any pointers to resolve this will be greatly...
Mitesh Shah
|
05-11-2012 02:39 PM
Adrian Klaver | 1 | 7 |
| | | Hi,
is an alias name not usable in the where clause?
select EXTRACT(day from enddate::TIMESTAMP - old_enddate::TIMESTAMP) AS TAGE from account_h ...
Marcel Ruff
|
05-04-2012 08:05 AM
Thomas Kellerer | 2 | 29 |
| | | Marcel Ruff <mr (AT) marcelruff (DOT) info> hat am 4. Mai 2012 um 12:25 geschrieben:
Exactly.
Andreas
--
Sent via pgsql-sql mailing list...
Andreas Kretschmer
|
05-04-2012 07:40 AM
Andreas Kretschmer | 0 | 10 |
| | | There used to be a switch in pg_dump that would disable the version, you can
even see that's in the man page. However, it is not reccommended and the...
Robert Bernier
|
05-02-2012 05:27 PM
Robert Bernier | 0 | 15 |
| | | Mitesh Shah <mitesh.shah (AT) stripes39 (DOT) com> wrote:
This is not a bug. Use a version of pg_dump which is at least as
new as the server. The...
Kevin Grittner
|
05-02-2012 04:53 PM
Kevin Grittner | 0 | 16 |
| | | Hi,
can I realize a running mean filter using window functions?
What I can think of is:
SELECT avg(random) OVER (PARTITION BY floor(time_s / 60)...
Andreas Gaab
|
04-26-2012 04:22 AM
Andreas Gaab | 0 | 19 |
| | | I'm trying to INSERT into a table, avoiding duplicates, using this sort of
thing:
-- --
insert into buddyinvite (bi_user, bi_invited)
select 'a',...
Peter Harris
|
04-25-2012 12:26 PM
Greg Sabino Mullane | 3 | 20 |
| | | Hi,
I am pretty new to this Postgresql , PgFouine and all that stuff. I took
the log that was generated by the postgresql (i.e in the...
Venkateswara Rao Dokku
|
04-25-2012 12:55 AM
Venkateswara Rao Dokku | 0 | 12 |
| | | Hi,
is there a generic solution to dump the result of a query as a crosstab,
when I can't know how many columns I will need?
E.g. I get something...
Andreas
|
04-25-2012 12:07 AM
Samuel Gendler | 7 | 16 |
| | | Hi,
I'm trying to get an idea about pg_trgrm.
I created a GIST index on a text column in a table.
Now I can filter the table with similarity().
How...
Andreas
|
04-24-2012 10:46 PM
Trinath Somanchi | 1 | 7 |
| | | Good morning,
May I know is there a simple sql command which could return missing
numbers please?
For example,
t1(id integer)
values= 1, 2, 3...
Emi Lu
|
04-24-2012 01:56 PM
Steve Crawford | 6 | 14 |
| | | Aha, generate_series, I got it. Thank you very much!!
I also tried left join, it seems that left join explain analyze returns
faster comparing with...
Emi Lu
|
04-24-2012 10:21 AM
Emi Lu | 0 | 8 |
| | | Hi,
In my app it is possible to login as one name and use a different name to
login to postgres.
Is it possible to get the actual OS login name...
John Fabiani
|
04-24-2012 04:48 AM
Jasen Betts | 3 | 22 |
| | | When a query is written to update a table, the usual process is to list all the columns that need
updating. This could imply the creation of many...
Dennis
|
04-19-2012 01:32 PM
Rob Sargent | 4 | 31 |
| | | (sorry my previous email was truncated)
hi,
Here is what I want to do :
I want to check each row of a table against some conditions (this
check...
thomas veymont
|
04-19-2012 06:58 AM
Pavel Stehule | 5 | 23 |
| | | hi,
say I have the following (simplified for discussion) pl/pgsql function:
FUNCTION myfunction ( ...) RETURNS TABLE ( elem1 integer, elem2 text,...
thomas veymont
|
04-18-2012 12:41 PM
thomas veymont | 0 | 11 |
| | | Hello
this is not error, you cannot use predicate IN in this context
use =ANY instead
postgres=> select 10 = ANY(ARRAY);
?column?
----------
f
Pavel Stehule
|
04-16-2012 09:30 AM
Pavel Stehule | 0 | 19 |
| | | I have a table with a varchar field, such a field is HTML ENCODED. So, for
example, the string "PLAIN WHITE T'S" is saved as "PLAIN...
JORGE MALDONADO
|
04-12-2012 07:26 AM
Jasen Betts | 2 | 26 |
| | | I'm trying to update a customer record in a table however I need to
change several values (cust_address, cust_contact, cust_email). My
question is...
Carlos Mennens
|
04-11-2012 03:55 PM
Thomas Kellerer | 1 | 28 |
| | | On 19/02/10 07:52, iuri de araujo sampaio wrote:
I thought it was the PERFORM statements, but it's not. The line number
seems right, although the...
Richard Huxton
|
04-11-2012 09:29 AM
Tom Lane | 3 | 201 |
| | | hi,
is there a disadvantage to write a join as
select *
from a, b
where a.id = b.a_id;
over
Andreas
|
04-06-2012 03:14 PM
Rob Sargent | 4 | 24 |
| | | Hello,
I have an extremely bad plan for one of my colleague's query. Basically
PostgreSQL chooses to seq scan instead of index scan. This is...
Julien Cigar
|
04-05-2012 09:29 AM
Julien Cigar | 5 | 23 |
| | | hi every one
i have created this simple function which returns a column of table , i have used simple SELECT statement , i simply want to know how...
La Chi
|
04-04-2012 02:36 AM
Pavel Stehule | 1 | 15 |
| | | I have a parent table and a child table. In order to detect duplicate
information I need to consider both tables. This means that a...
JORGE MALDONADO
|
04-03-2012 11:16 PM
msi77 | 1 | 16 |
| | | Hi folks.
I have two selects which in themselves report what they should. However, when
I run a union to combine their outputs (to then feed a...
Gary Stainburn
|
04-03-2012 05:49 AM
Jasen Betts | 3 | 31 |
| | | Hello every one
i have created this function to test cursors , but when i execute this funtion it give me this error , how can i fix this...
La Chi
|
04-03-2012 04:23 AM
La Chi | 0 | 11 |
| | | Hello everyone,
i have created this function in which i simply want todisplay a column values through a cursor , but*unfortunately*i am not getting...
La Chi
|
04-03-2012 02:44 AM
La Chi | 0 | 10 |
| | | hi ,
how can we concatinate these lines and execute sql command
*
* * * *setsql ='select user,username,
firstname '
***** set sql +=' lastname,...
Rehan Saleem
|
03-27-2012 11:12 AM
Steve Crawford | 4 | 26 |
| | | hi everyone ,
i have converted a ms-sql store procedure into*PostgreSQL*function , but my*PostgreSQL*function is not giving the same output as my...
Rehan Saleem
|
03-26-2012 05:01 AM
Rehan Saleem | 0 | 15 |
| | | hi,
i am trying to convert this mssql store procedure to postgresql function but it is not giving me the desired output ,this function is returning a...
Rehan Saleem
|
03-26-2012 02:49 AM
Rehan Saleem | 0 | 16 |
| | | Hi,
I know this is a newbie question but I have never had the need to do the
following.
I start a transaction.
Begin
Then I insert a lot of data -...
John Fabiani
|
03-23-2012 04:25 PM
Tim Landscheidt | 6 | 22 |
| | | I am currently using lower(column) = '' for matching case insensitive. I
know that there are ways to do this with regular expressions too. I...
Edward W. Rouse
|
03-22-2012 03:05 PM
Edward W. Rouse | 2 | 17 |
| | | Is there a single function that will generate a series and return an array?
The best I've come up with is to combine array_agg and...
Lee Hachadoorian
|
03-22-2012 02:02 PM
Pavel Stehule | 1 | 18 |
| | | The function calculates the data line by line, and inserts into the
table, at the end of the function I need to send data from a table to
another...
Bear
|
03-21-2012 02:30 AM
Bear | 0 | 18 |
| | | Hi all,
running pg 8.3.5 on RHEL (no, they won't upgrade anyway and yes, they know
they should).
I currently have an emergency problem with an...
Bèrto ëd Sèra
|
03-20-2012 09:24 AM
Bèrto ëd Sèra | 4 | 28 |
| | | hi ,
how to write a function which should read data from 2 tables having same number of columns and should show the common values from those...
Rehan Saleem
|
03-19-2012 09:21 PM
Jayadevan M | 4 | 18 |
