In response to Iñigo Barandiaran :
> Hi.
>
>
> I would like to create a new table where one of the field would be a
> user password. Is there any data type for supporting this functionality?
> Something like Password DataType. I've taken a look of the available
> data types in PgAdmin Applicat
In response to Kusuma Pabba :
> when i use
> /usr/local/pgsql/bin/psql test
> this i am getting following error
> psql: could not connect to server: No such file or directory
>Is the server running locally and accepting
>connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> s
In response to Kusuma Pabba :
> hello all,
>i have used a file containing all the queries and directly executed
> the file to create tables in mysql, now i want to use the same for psql
> is it
> possible?
Sure, psql -f or within psql with \i.
Andreas
--
Andreas Kretschmer
Kontakt: Heyn
In response to Eus :
> Hi Ho!
>
> Is there a way to check whether or not a subquery returns an empty result set?
You can use EXISTS for that:
-- empty result
test=*# select * from (select 1 where 1=2) foo;
?column?
--
(0 rows)
-- check if a result exists
test=*# select exists(select *
In response to Craig Ringer :
> I don't understand what you want based on your description and your
> example results. What do you mean by "if the column `b' have the same
> value" ?
Additionally, don't hijack other threads by answer to an old message and
changing the subject. Your eMails contai
In response to Yi Zhao :
> thanks Ringer.
> my mean is that:
> I want less than 2 rows which have the same value of column "b"!
>
> for example, there is 3 columns have the same value "A",
> X | A
> X | A
> Y | A
> I want my result have two of them.
I think, you are searching for DISTINCT:
te
In response to Yi Zhao :
> ok, thanks, I will create a new message when I post next time.
>
> about my question, I think distinct can't solve my problem, because I
> want to get more than one rows. if there is more than (or equal) 2 (eg:
> 2, 3, 4, 100 ...)rows have the same value of column 'b' ,
In response to Igor Katson :
> I think I need a built-in function to make a column from an array, like
> in the backwards operation SELECT ARRAY(column)
By David Fetter:
CREATE OR REPLACE FUNCTION unnest(ANYARRAY) RETURNS SETOF ANYELEMENT
LANGUAGE SQL AS $$SELECT $1[i] FROM
generate_series(array
In response to Mike Christensen :
> Won't I still need a column definition list when I call that since it returns
> SETOF record?
You have to provide a column definition, either as OUT-parameter
definition or as column definition list in the select.
Please, don't top-posting.
Andreas
--
Andrea
In response to Eus :
> Hi Ho!
>
> The following query works well:
>
> select count (*)
> from item_audit
> where audit_ts >= '2008-05-30 00:00:00'
>and audit_ts <= '2008-10-30 00:00:00'
>and 'wst' != (select split_part(category, '-', 2)
> from description
>
In response to najmuddin hassan :
> Hi,
>
> I just installed a program called moteview by crossbow technologies. It uses
> postgreSQL 8.0.0-rc1 for its database. There is something wrong as when I
> launched the program it automaticly gives me an error that the database is not
> available. The po
In response to Abdul Rahman :
> Hi all,
>
> Is there any preferably open source tool to convert Oracle Functions to
> PostgreSQL Functions.
Maybe orafce, see http://pgfoundry.org/projects/orafce/
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header
In response to Linos :
> Hello,
> i have a query that returns a result set like this:
>
> item | size | stock
> 123 | XL | 10
> 123 | XXL | 5
> 123 | XS | 3
>
> and i would like get the results like this:
>
> item | XL | XXL | XS
> 123 | 10 | 5 | 3
Other solution with plain S
In response to James Dooley :
> Hi,
>
> Since PostgreSQL is by default case sensitive, I would like to know if it is
> possible to do a search or somehow set the column in a relation to be case
> insensitive (on search at least).
>
> I would however like to store it case sensitive so I can displa
In response to Stefan Kaltenbrunner :
> Tino Wildenhain wrote:
> >Greg Smith wrote:
> >>On Wed, 4 Mar 2009, Artacus wrote:
> >>
> >>>So it looks like at one time we had a cookbook. But the links are
> >>>dead now.
> >>
> >>I'm not sure why Roberto Mello stopped hosting that, but you can see
> >>t
In response to Thom Brown :
> Hi,
>
> This may be a stupid question, but I can't find any guide in the documentation
> which tells me the answer. How do I install a module for PostgreSQL in
> Linux?
> For example, how would I install uuid-ossp? I can't find any options in
> postgresql.conf whi
In response to Venkat Rao Tammineni :
> Dear All,
>
>
>
>
>
> I have one table which has lot of data.In the same table I have one varchar
> filed. I want to convert into Date data type? Is It possible to convert
> varchar
> to date datatype with out loosing data.Please guide me.I am waiti
In response to John Wang :
>
> How to combine psql commands, such as "\copy", with shell script? Is there
> any sample code? For example, I have 10 tables and want to user the "\copy"
> command to import data from 10 different text files. I can execute the
> "\copy" command 10 times. But it is
In response to Kynn Jones :
> Is there a reliable way to find out the (Unix) PID associated with a database
> handle generated by Perl DBI's database connection?
You can ask the pg_stat_activity - View, column procpid.
HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 01
In response to Martin Gainty :
> pg clients communicate on 5432 so a simple search on 5432 will yield the pid
> e.g.
> netstat -aon | grep 5432
Thats no useful:
- you can't do that from the client (across the network)
- you can't see which pid has a particular client
Regards, Andreas
--
Andrea
In response to linnewbie :
> I am using tcl ( ncgi and tclobdc ) so it is more like the excerpts
> below:
>
> ie I input:
>
> Hello World
>
> xyz
> .
>
> into the text area field, save:
>
> set page_content [ ncgi::value textarea_field_name]
>
> database connect dbh $datasource $d
In response to Scott Marlowe :
> On Thu, Apr 2, 2009 at 11:55 PM, Gordon Shannon wrote:
> >
> > What I'm trying to do doesn't seem like it should be that difficult or
> > unusual, but I can't seem to find the right combination of commands to make
> > it happen. I want to have a log file that capt
In response to Kashmir :
>
> cant seem to find anything about this,
> would it possible at all to create a percentile-aggregate in pgres?
> any pointers?
> tia
> -k
I'm not sure if i understand your problem, but how about:
test=*# select * from percentile ;
id | value
+---
1 |10
In response to Abdul Rehman :
> Hi all,
>
> Can any body help me in converting numeric values into words via postgres
> function: i.e. 313 to THREE HUNDRED THREE
You can use the PERL-Module from
http://search.cpan.org/~sburke/Lingua-EN-Numbers-1.01/lib/Lingua/EN/Numbers.pm
and plperlU
Andreas
-
In response to ahmed soua :
> Hi everybody,
>
> When I was working with Postgis , I had the following error:
> failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une fonction ou
> d'une chaîne
> contenant plusieurs commandes ( VACUUM cannot be executed from a function or
> from a chain
In response to Kaarel Kitsemets :
> Hi
>
> I need to make a change to a table that many stored procedures depend
> on. Is there an automatic way of finding all the functions that depend
> on a certain table?
Not really, but for functions written not in C you can ask the column
prosrc from the t
In response to Shug Boabby :
> Hello all,
>
> I have a table with 2 bigint columns, let's call them A and B. I need
> a query that will allow me to return A alongside the sum of Bs from
> rows where A is less than or equal to this row's A. It is best
> described with some example data, consider th
In response to ahmed soua :
> Hi all,
> when i was executing this command : osm2pgsql --slim -v -d gis /home/
> ahmed/GreatLakes.osm.gz
> i had obtained this error :
> failed: ERREUR: VACUUM ne peut pas être exécuté à partir d'une
> fonction ou d'une chaîne
> contenant plusieurs commandes ( VACU
In response to Bill Todd :
> I am trying to connect to a PostgreSQL server from another machine on my
> small home network. When I click the Test button in the ODBC data mnager
> for my system DSN I get the error "No connection could be made because
> the target machine actively refused it." Tha
In response to S Arvind :
> I set log_min_duration_statement to 1 and restart the postgres. But when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?
log_statement = all loggs _all
In response to David :
> Our internal task database is doing something odd in that the sequence is
> incrementing by 2 instead of 1 and I can't find any reason why I have checked
> the
> sequence itself to see if it had somehow got set to increment by 2 but no.
> The table in question has a num
In response to Tim Uckun :
> Does anybody know if there is a sample database or text files I can import to
> do some performance testing?
>
> I would like to have tables with tens of millions of records if possible.
It is easy to create such a table:
test=# create table huge_data_table as select
In response to Tim Uckun :
> Thanks I'll try something like that.
>
> I guess can create some random dates or something for other types of fields
> too.
Sure, dates for instance:
test=*# select (current_date + random() * 1000 * '1day'::interval)::date from
generate_series(1,10);
date
--
In response to Developer :
> How to "listen" only in local socket?
Set in your postgresql.conf:
listen_addresses = ''
(uncomment this line and set the value to '')
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, priv
In response to Allan Kamau :
> Hi
>
> I would like to calculate a product of a field's values of a relation,
> this function may multiply each value and give the result as a single
> float number.
>
> For example:
>
>
> CREATE table imaginary(id INTEGER NOT NULL, some_field FLOAT
> NULL,prim
In response to Jasen Betts :
> > Is there an already existing function that does this.
>
> here's one way to cheat: logarythms.
>
> select exp(sum(ln( thiscolumn ))) from foo;
>
> :^)
nice ;-)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header
In response to George Weaver :
> Hi,
>
> I have a client with a main office and a branch office about 90 miles away.
>
> They have a server at the main office but it is not a web server.
>
> What would be the best solution for them to access a PostgreSQL database
> located at the main office
In response to kelvin273 :
>
> Hi all,
> i'm using postgresql 8.3 and i have create a very simple script for insert
> data into database (because i'm testing it, i create and drop/mod frequently
> the tables).
> My script is this:
>
> #!/bin/bash
> echo "Insert start"
> psql -U myself -d test -f
In response to David :
> Hi there.
>
> I never found an adequate (simple and efficient) method for getting
> the primary key ID of the just-inserted row, and usually used
> transactions and "select last value, ordered by id"-type queries to
> get the last id value, or other ugly logic.
use currva
am 17.08.2005, um 13:48:38 -0300 mailte Fernando Lujan folgendes:
> Hi folks,
>
> I have a table wich contains my users... I want to insert to each user
> a random password, so I need a random function. Is there such function
> in Postgres? I just found the RANDOM which generates values between
>
am 17.08.2005, um 15:12:55 -0300 mailte marcelo Cortez folgendes:
> Hello all,
>
> does anyone know, whether there is a
> Debian Package for postgresql 8.x for stable version?
> Thanks in advance.
I'm useing 8.0.3 from testing in Debian/Stable without problems.
Regards, Andreas
--
Andreas Kre
am 18.08.2005, um 12:36:26 -0500 mailte Peter Fein folgendes:
> Hi-
>
> Is there any way to have the *server* timeout disconnected clients? I'm
> connecting over a sometimes flaky WiFi connection & when it goes down,
> I'm left with several open idle sessions. Is there a way to have the
> serve
am 19.08.2005, um 0:27:40 -0700 mailte Bill Moseley folgendes:
> I'm entering data into a Postgresql database where the input dates are
> currently in unix epoch values. Is there a way for Postgresql to
> parse that epoch into a "timestamp(0) with time zone"?
SELECT TIMESTAMP WITH TIME ZONE 'ep
am 19.08.2005, um 12:07:57 +0100 mailte Nigel Horne folgendes:
> The on-line manual,
> http://www.postgresql.org/docs/8.0/interactive/index.html,
> doesn't describe how to call stored functions, or if it does
> it's well hidden.
test=# create function get_foobar () returns varchar as $$begin retu
am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> I can't work out from that how to return more than one value.
17:35 < rtfm_please> For information about srf
17:35 < rtfm_please> see
http://techdocs.postgresql.org/guides/SetReturningFunctions
17:35 < rtfm_please> or
http://www.p
am 19.08.2005, um 16:38:20 +0100 mailte Nigel Horne folgendes:
> On Fri, 2005-08-19 at 16:30, Adam Witney wrote:
> > > I can't work out from that how to return more than one value.
> >
> > Hi Nigel,
> >
> > Add SETOF to your function like so:
> >
> > CREATE TABLE test (id int);
> > INSERT INTO
am 19.08.2005, um 11:34:52 -0500 mailte Tony Caduto folgendes:
> Is it possible to write c style functions with Free Pascal?
Please, if you open a new subject, then open also a new thread in this
email-list. Your messages are always in a wrong thread.
Regards, Andreas
--
Andreas Kretschmer
am 23.08.2005, um 0:24:53 +1200 mailte Bernard folgendes:
> SELECT
> DEPARTMENT.PK,
> DEPARTMENT.NAME,
> MIN(PROJECT.VALUE)AS RATING
> FROM DEPARTMENT,
> PROJECT
> WHERE DEPARTMENT.PK=PROJECT.DEPARTMENT_FK
> GROUP BY DEPARTMENT.PK
> ORDER BY DEPARTMENT.PK;
>
> ERROR: column "department.na
am 22.08.2005, um 14:56:09 +0100 mailte Nigel Horne folgendes:
> > > How does that help with my problem? I seems to discuss returning more
> > > than one row of a table which is not the question I asked.
> > >
> >
> > try to tell your questions more precisely :-)
>
> I want to return more than
am 22.08.2005, um 22:13:49 +0200 mailte Ben-Nes Yonatan folgendes:
> I think that I was misunderstood, Ill make an example:
Okay:
> Lets say that im making the following query for the first time on the
> "motorcycles" table which got an index on the "manufacturer" field:
>
> EXPLAIN ANALYZE SE
am 23.08.2005, um 15:12:54 +0530 mailte Vishnu folgendes:
> Hi,
>
> How can I limit the maximum space uses by Posgres database ??. So that it
> should not use total disk space available on system.
You can use the tools from the os, under Linux for instance quotas.
You can also put the data dir
am 23.08.2005, um 11:47:57 -0300 mailte Rodrigo Africani folgendes:
> Hi,
>
> I'm trying to import a sequence txt file.
> The file has fix columns ... i.e the first 10 positions is the primary key ...
> The comand copy need a delimitier but the file is seq without a delimitier.
> I look in the ma
am 26.08.2005, um 2:11:30 +0430 mailte Lee Harr folgendes:
> >I have not been able to work out how to do this is Postgres 8
> >(pseudo-code)
> > if exists table foo
> > drop table foo;
> > end
> > create table foo;
> >If I go with
> > drop table foo;
> > create table foo;
> >then it barfs on
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
> How can I connect to remote server from a remote personal computer
> without its own IP adress ?
You can connect to the remote server via ssh. Then you are a local user.
SSH is a highly secure protocol, i suggest, use ssh with Publ
am 05.09.2005, um 14:26:31 -0300 mailte Sidnei de Souza folgendes:
> Is it possible to pass a table name and/or schema name to a plpgsql
> function?
Yes.
> How can I use them in the code? Which Types to use for each of the
> parameters?
varchar.
>
> E.g.
>
> create or replace function MyTe
am 06.09.2005, um 20:13:57 +1000 mailte Peter Cook folgendes:
> My installation has stalled with the following message:
> "User 'postgres' could not be created. The user account already exists!"
Which OS?
Maybe it is useful to delete this account first.
Regards, Andreas
--
Andreas Kretschmer
am 07.09.2005, um 1:01:11 -0700 mailte Matthew Peter folgendes:
> How many rows does it take for select performance on a
> table to degrade? I hope this question isn't to
> ambiguous (ie lollipop licks). But seriously, 100,000?
> 1,000,000? 10,000,000? With just a regular lookup on
> an unique in
am 12.09.2005, um 17:08:31 +0530 mailte suresh ramasamy folgendes:
> hi,
>
> i'm new to postgreSQL as well as new to database concepts. please tell me
> how can i learn. i mean the easiest and fast way. Your help will be
Read a book.
http://techdocs.postgresql.org/techdocs/bookreviews.php
Re
am 16.09.2005, um 6:51:16 -0700 mailte Nitin Ahire folgendes:
> I am facing problems for stored procedures. Is their any way so that I
> can transfer my existing stored procedure from mssql to postgre ?
I guess: no.
>
> I already read about functions & tried to implement it but I could not
>
am 21.09.2005, um 15:53:45 +0200 mailte Bohdan Linda folgendes:
> Hello,
>
> may I ask, how(or which) ip is checked against pg_hba.conf IP entry in NAT
> environment?
>
> Could it be, that psql client packs IP address of the client into
> athentication data?
No. Why? Describe your problem.
p
am 22.09.2005, um 12:40:00 +0300 mailte [EMAIL PROTECTED] folgendes:
>
> select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
> 00:00:00'
Which version?
test=# select date_trunc('week', '2005-01-01'::TIMESTAMP);
date_trunc
-
2004-12-27 00:00:00
(1 ro
am 28.09.2005, um 22:48:06 -0700 mailte TheNice Spider folgendes:
> Hi,
>
> Currently I have serious problem to migrate a "production" MS SQL 2K to
> Postgres 8 for Windows.
> Is there any tools to import MS SQL 2K to Postgres 8 including:
> - PK and FK
> - View, Trigger, Store Procedure
> - U
am 29.09.2005, um 9:20:00 +0200 mailte Rafael Montoya folgendes:
> Ok, there are about 15 concurrent clients inserting and updating data, and
> 20 concurrent clients only consulting.
> I dont need all data in ram, of course, hehe, but i really have no idea
> what's the minimum of ram for havin
am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes:
> Is there any support for perl regular expressions
> in Postgresql?
Yes, you can use perl regex in plperl.
http://www.postgresql.org/docs/current/static/plperl.html
Regards, Andreas
--
Andreas Kretschmer(Kontakt: siehe H
am 29.09.2005, um 9:14:39 -0400 mailte Sean Davis folgendes:
> On 9/28/05 6:25 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> > Is there any support for perl regular expressions
> > in Postgresql?
>
> You might want to look at this section of the documentation:
>
> http://www.postgresq
am 29.09.2005, um 20:08:17 +0200 mailte Craig folgendes:
> Hi
>
> What is the best tool for debugging pl/pgsql functions?
> Any suggestions would be appreciated
RAISE NOTICE 'foo %', bar;
Read: http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html
Regards, Andreas
--
Andreas Kretsc
am 30.09.2005, um 10:55:44 -0400 mailte Emi Lu folgendes:
> Greetings,
>
> I am not very familiar with the system views/tables in postgreSQL. I'd like
> to get all table names that have a column let's say named "col1".
select table_name from information_schema.columns where column_name = 'col1'
am 03.10.2005, um 18:48:03 +0530 mailte Aman Tur folgendes:
>
>
> I have installed PostgreSQL 8 and latest pgODBC and ADO drivers but still I
> am not able to connect to it from access or VB 6. Kindly help me.
Instead HTML-mail with a picture you should better post a detailed
error-message and
am 04.10.2005, um 5:00:16 -0700 mailte ctobini folgendes:
> Hello,
>
> I don't find in the PostgreSQL doc how to export a select result in a
> text file.
>
> Thanks if you can help me.
You can use \o in psql to redirect the result to a file.
\o out.file
Regards, Andreas
--
Andreas Kretschm
am 05.10.2005, um 10:54:47 +0530 mailte Nitin Tarkar folgendes:
> Dear All
>
> Kindly guid us to export PostgreSQL Database from linux to windows.
Use pg_dump to export and psql/pg_restore to import.
Read the man-page for pg_dump, particulary the different output formats.
And, you should use th
am 05.10.2005, um 15:08:33 +0200 mailte Robert Osowiecki folgendes:
> Hello!
>
> Anyone could explain to me, why cast(3.33 to int) works (from float, I
> suppose) but cast('3.33' to int) (from text) does not? And what if I
> create a cast for that: is it possibly dangerous?
test=# select '3.3
am 06.10.2005, um 13:59:44 +0300 mailte WireSpot folgendes:
> Is it possible to dump an entire database but to skip one or two tables? Or,
> conversely, to restore an entire dump except for one or two tables?
> (Although I'd prefer the first version.)
>
> The only related option for both pg_dump
am 06.10.2005, um 15:29:50 +0300 mailte WireSpot folgendes:
> > > The only related option for both pg_dump and pg_restore is --table, which
> > > only takes 1 (one) table name. If only it accepted more than one I
> > > could've
> > > found a workaround.
> >
> > You can use the -t more than once.
am 06.10.2005, um 22:33:52 +0800 mailte CN folgendes:
> Hi!
>
> 8.0.1 and 8.1 beta.
>
> Triggers are still fired although option --disable-triggers is applied
> to pg_restore. The fired triggers abort pg_restore because of the
> foreign keys violations.
>
> The following restore script used to
am 12.10.2005, um 20:42:02 +0200 mailte peter pilsl folgendes:
>
> the count-aggreate counts every expression that does not evaluate to null.
>
> I would like to have a count that counts all values that are true.
>
> Do I really need to make a count( case when expression then 't' else null)
>
am 13.10.2005, um 3:36:19 -0700 mailte Josephine E. de Castro folgendes:
> Hi everyone,
>
> I just want to know if there is an equivalent method in PostgreSQL
> that acts like SQL Server's extended stored procedure. I want to run a
> stored procedure that can update a file in the file system.
am 13.10.2005, um 23:36:26 -0700 mailte srikanth potluri folgendes:
> hi ,
>
> can any one send me the setailed step by step installaiton guide of
> postgre-sql on linux .
Which distribution? You should use the distribution packet system.
http://www.oryx.com/ams/postgresql.html
Regards, And
am 19.10.2005, um 14:36:46 +0200 mailte Marcel Gsteiger folgendes:
> Hi all
>
> Does anybody know how I could create a database function that accepts
> an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
> Something like the dnsname command line utility in the djbdns package. I
am 26.10.2005, um 14:52:36 +0200 mailte Zlatko Mati? folgendes:
> Hello.
>
> Is there any way to check the version of PostgreSQL by a query? Maybe by
> querying catalog tables?
> Thanks,
select version();
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz: 035242/47212,
am 26.10.2005, um 10:22:27 -0300 mailte Rodrigo Gonzalez folgendes:
>
>
>
>
>
>
> select version()
>
> Zlatko Mati? wrote:
> type="cite">
>
>
>
> Hello.
>
> Is there any way to check the
> version of PostgreSQL by a query? Maybe by querying catalog
> tables?
> Thanks
am 27.10.2005, um 11:13:43 +0200 mailte Frederic Massot folgendes:
> Hi,
>
> I wonder whether it is possible to copy a schema with a postgreSQL command
> like "copy_schema schema_src schema_dest" ?
You can rename a schema. And, you can make a dump, then rename it, and
then restore from backup.
am 29.10.2005, um 20:39:23 -0700 mailte Matthew Peter folgendes:
> Could someone help me and give me a basic example of
> how to write a similiar functional function to the one
> below that would use a dynamic table and update a
> column only if it held a value.
http://www.postgresql.org/docs/8.
am 31.10.2005, um 13:11:20 -0500 mailte DEV folgendes:
> Is is possible to use replace along with regular expression to remove any
> and all punctuation from a field?
Which version?
PG 8.1 have a function 'regex_replace'.
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz:
am 01.11.2005, um 13:01:54 -0500 mailte DEV folgendes:
> Currently I am running 8.0.1. Looks like an upgrade is in my future. Oh
> Joy LOL
>
> am 31.10.2005, um 13:11:20 -0500 mailte DEV folgendes:
> > Is is possible to use replace along with regular expression to remove any
> > and all pun
am 02.11.2005, um 9:35:33 -0700 mailte Michael Fuhr folgendes:
> test=> SELECT id, md5(textin(record_out(foo))) FROM foo;
is 'record_out()' new in 8.1?
Regards, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://ww
am 06.11.2005, um 22:54:15 + mailte Chris folgendes:
> Andreas Kretschmer spamfence.net> writes:
> > Chris gmail.com> schrieb:
> >
> > > How do I create a virtaul column?
> >
> > A view. Example:
>
> Is a view completely compatible with tables? I mean, can I do everything with
> a
> view
am 09.11.2005, um 9:00:08 +0200 mailte Riaan van der Westhuizen folgendes:
> Hi All
>
>
>
> Where do I find the Debian apt-get source path for PostgreSQL 8.1
deb http://people.debian.org/~mpitt/packages/sarge-backports/ /
8.1 on my sarge is running ;-)
[EMAIL PROTECTED]:~$ echo "selec
am 09.11.2005, um 5:40:14 -0800 mailte ctobini folgendes:
> Hello,
>
> I would like to know how to liste the contain of a fonction.
You can find this in information_schema.routines.
>
> Writing \df in psql, I have a list of functions and triggers, but and
> don't know how to obtain the code
am 10.11.2005, um 1:45:46 +1100 mailte Alex folgendes:
> Hi,
> have just a general question...
>
> I have a table of 10M records, unique key on 5 fields.
> I need to update/insert 200k records in one go.
>
> I could do a select to check for existence and then either insert or
> update.
> Or si
am 10.11.2005, um 10:10:22 +0100 mailte Maik Trömel folgendes:
> Hello!
>
> I want to run a shell script with variables under Postgresql.
>
> An example:
> I want to make the following query;
>
> select * from tablename where id=1;
> select * from tablename where id=2;
> select * from tab
am 10.11.2005, um 12:46:33 +0100 mailte Piechu Piechu folgendes:
> hello
>
> I'm new in this list, so sorry if my question seems stupid
>
> Is it possible to invoke store procedure because of time, I mean for
> example I want my procedure to be invoked every ten minutes - what
> should I do to r
am 10.11.2005, um 14:58:14 +0100 mailte Maik Trömel folgendes:
> Now, my question:
> Why time zone "+02" in "2005-08-02 05:00:00+02"? And why "+01" in
> "2005-11-10 14:16:41+01"?
2005-08-02: summertime
2005-11-10: normal time
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heyn
am 13.11.2005, um 17:04:37 -0800 mailte The Nice Spider folgendes:
> Which version of PG support updatable view?
None. Updateable views are a 'TODO'.
http://www.postgresql.org/docs/faqs.TODO.html
You can use Rules instead:
http://www.varlena.com/varlena/GeneralBits/111.php, Issue 82-4
HTH, And
am 16.11.2005, um 18:52:25 +0200 mailte [EMAIL PROTECTED] folgendes:
>
> I want to write a trigger that logs any changes that are made to a row. I
You ivent the wheel the second time ;-)
http://pgfoundry.org/projects/tablelog/
> have the old an new row values, but I am more interested in know
am 24.11.2005, um 8:25:15 +0100 mailte Harald Armin Massa folgendes:
> Bruce,
> list,
>
> I translated that part to german, I know the source is strong in Germany -
> maybe it can be a helpfull addition - even if most speak English, they are
> even more happy to read sth. in German.
Nice Idea ;
am Mon, dem 18.09.2006, um 15:13:10 +0800 mailte CN folgendes:
> SELECT * FROM t2 WHERE a='const_id'
>
> , then 3 records will be inserted to table t1:
>
> const_id, 1
> const_id, 2
> const_id, 3
>
> I know a PL/PGSQL function like this does the job:
You can use this:
test=# select * from t2;
am Tue, dem 19.09.2006, um 6:11:12 -0700 mailte Lukasz folgendes:
> Hello,
>
> I would like to install a PostgreSQL. I know how to manage the database
> itself, creae databases, user, groups and so on. But I don't know how
> to allow other users, who are outside LAN to connect to database
> thro
am Mon, dem 25.09.2006, um 2:56:47 +0200 mailte Markus Grabner folgendes:
>
> Hi!
>
> As far as I understand, one can simulate updateable views in PostgreSQL
> by
> providing appropriate query rewrite rules. Is there any tool to automatically
> create these rules for a given set of
am Sun, dem 24.09.2006, um 18:45:12 -0700 mailte [EMAIL PROTECTED] folgendes:
> Is there a 'drop if doesnt exist' or a better way of doing it?
8.2, read
http://developer.postgresql.org/pgdocs/postgres/release-8-2.html
DROP object IF EXISTS
HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz:
am Thu, dem 28.09.2006, um 9:46:29 +0200 mailte [EMAIL PROTECTED] folgendes:
> Hello all!
>
> Is it possible to define a complex return type like a record in a function
> without having some table around with the needed structure of the return
> values?
Yes, you can define a new type:
CREATE T
401 - 500 of 754 matches
Mail list logo
