in=> select distinct(x.case) from (select (case when substring('Hi
How are you' from r for 1) = ' ' then r else null end) from
generate_series(0, length('Hi How are you')) as r) as x;
case
--
3
7
11
--
Pawel Socha
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
2008/12/8 ss_postgres <[EMAIL PROTECTED]>:
>
>
> On Mon, Dec 8, 2008 at 5:44 PM, Pawel Socha <[EMAIL PROTECTED]> wrote:
>>
>> 2008/12/8 ss_postgres <[EMAIL PROTECTED]>:
>> > Hi,
>> >
>> > I am trying to find the position
BD ERROR: OCIServerAttach) at
> line 19
>
>
> ERROR: error from Perl function: ORA-12154: TNS:could not resolve the
> connect identifier specified (DBD ERROR: OCIServerAttach) at line 19.
>
> I'm printing notices (as you see) i this function showing values of
> environment variables. They are the same as variables in postgres user on
> linux.
>
> Any idea what am i doing wrong?
>
> I'm thankful for any of Your help.
check $ORA_HOME
and settings in tnsnames.ora in $ORA_HOME dir.
Or try connect by host,port and SID.
:)
--
Pawel Socha
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
erlin>create table t10("Name" int);
CREATE TABLE
Time: 201.221 ms
--
Pawel Socha
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
add postgres user in osx ;]
Solution:
http://www.postgresql.org/docs/8.3/interactive/postgres-user.html
;]
--
Pawel Socha
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
