On Thu, May 25, 2017 at 6:00 PM, Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> The way I do it is the following :
> - ensure a common sequence for the ID for all tables in the inheritance
> tree (usually one parent and one or more children)
> - enforce normal FK constraints for all
);
select * from myt;
id
1
2
create table a (id integerreferences myt(id));
insert into a values(2);
ERROR: insert or update on table "a" violates foreign key constraint
"a_id_fkey"
DETAIL: Key (id)=(2) is not present in table "myt".
Regards,
Jayadevan
myschema.table1; | SET search_path TO myschema,public
PG version :
PostgreSQL 9.4.5 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux)
4.8.5, 64-bit
Thanks,
Jayadevan
rows=12 width=4) (actual
time=0.000..0.000 rows=0 loops=1)
Filter: (id = 1)
* -> Seq Scan on child3 (cost=0.00..40.00 rows=12 width=4) (actual
time=0.000..0.000 rows=0 loops=1)*
* Filter: (id = 1)*
Thanks,
Jayadevan
David J.
>
>
used. But why doesn't the planner just use
constraint exclusion and not go for the index scan? Anyone faced a similar
issue?
Thanks,
Jayadevan
he data will be found
and the table with 2500+ values in the check constraint. I may be missing
something?
I tried changing the filter from myuid in (1,2,3) to myuid = 1 or myuid = 2
or
It did not improve the plan. One Index Cond became 3 Index Cond .
Thanks,
Jayadevan
postgresql.conf is in $PGDATA. So they will be in the same directory?
Regards,
Jayadevan
On Sun, Jan 4, 2015 at 8:01 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 01/04/2015 06:09 AM, Jayadevan M wrote:
Hi,
I have streaming replication set up, with PostgreSQL 9.3. The entries in
recovery.conf on the slave are as follows -
standby_mode = 'on'
primary_conninfo = 'host
, right?
How many unique values are there in a column (cardinality), that is
estimated while finding out selectivity?
Regards,
Jayadevan
Will a rule work?
http://www.postgresql.org/docs/9.3/static/sql-createrule.html
On Wed, Apr 2, 2014 at 5:47 PM, loc c320...@gmail.com wrote:
I'm currently using an Informix Innovator-C database with Aubit4GL and I
would like to migrate to PostgreSQL, it looks like the transition will not
be
be equal to or greater than
the total cost of the inner nodes? (My guess is NO, there may be cases
where the outer node can start processing before the inner node is
completely done).
Regards,
Jayadevan
On Sat, Mar 15, 2014 at 1:51 AM, Andy Colson a...@squeakycode.net wrote:
On 3/14/2014 6:08 AM, Antman, Jason (CMG-Atlanta) wrote:
I'm not a high level committer, nor am I even a regular poster to this
list.
not saying this post is true, but... If I'm reading between the lines
correctly,
and
vote_up =1) . Is it better to have data type of Boolean, varchar or int?
I assume there isanother decision too - have 2 columns - one for up and one
for down, or have just one column which will be 1 or -1.
Regards,
Jayadevan
Sameer Kumar wrote
This only tells that there is one instance running!
There could be multiple PostgreSQL installations. And I guess that is what
Tom meant here.
I doubt that was what Tom meant. Anyway, we can see from the error that the
request did reach the server.
Sameer Kumar wrote
PGPORT=1234
PGUSER=postgres
PGHOST=localhost
On Sun, Jan 5, 2014 at 9:03 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 01/04/2014 08:46 PM, Jayadevan M wrote:
Log entries for 3 situations - 2 successful and one failed attempt -
From non-chroot, shell user postgres
2014-01-05 10:11:58
I am able to login as postgres with password from the same machine. So it
is not an expiry issue (as you too concluded). Output from strace is about
500 lines. I am pasting what I feel may be relevant. I hope this will be
useful.
execve(/usr/pgsql-9.3/bin/psql, [psql, -h, localhost], [/* 24 vars
: host=::1 port=47949
2014-01-05 10:12:51 IST [17052]: [2-1] user=postgres,db=postgres LOG:
connection authorized: user=postgres database=postgres
On Sat, Jan 4, 2014 at 8:43 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 01/03/2014 09:29 PM, Jayadevan M wrote:
There is only one instance
in the non-chroot
environment. I am also running a python application which uses psycopg2 and
that is working fine.
Regards,
Jayadevan
Nope -
psql -W
psql: FATAL: password authentication failed for user postgres
On Fri, Jan 3, 2014 at 2:49 PM, Ashesh Vashi
ashesh.va...@enterprisedb.comwrote:
Try psql -W for prompting the password forcefully.
On Fri, Jan 3, 2014 at 2:46 PM, Jayadevan M
maymala.jayade...@gmail.comwrote
I am able to login from the non-chroot environment. So it is not an issue
with pg_hba.conf and not an issue of password expiration. Is there a debug
psql option?
On Fri, Jan 3, 2014 at 5:09 PM, Chris Curvey ch...@chriscurvey.com wrote:
On Fri, Jan 3, 2014 at 4:16 AM, Jayadevan M
3, 2014 at 5:13 PM, Jayadevan M
maymala.jayade...@gmail.comwrote:
I am able to login from the non-chroot environment. So it is not an issue
with pg_hba.conf and not an issue of password expiration. Is there a debug
psql option?
OK.
Have you checked the PGPASSWORD environment variable
inconvenience, but I would like to resolve
this. The no password supplied message comes back so fast, it is as if it
did not even attemp to connect.
On Fri, Jan 3, 2014 at 8:37 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Adrian Klaver adrian.kla...@gmail.com writes:
On 01/03/2014 04:54 AM, Jayadevan M
?
Does the refresh result in exclusive locking?
Regards,
Jayadevan
To answer my own question, I saw this thread -
http://postgresql.1045698.n5.nabble.com/Efficiency-of-materialized-views-refresh-in-9-3-td5762618.html
I think that does answer my questions. Nothing has changed?
Regards,
Jayadevan
On Wed, Jan 1, 2014 at 6:42 PM, Jayadevan M maymala.jayade
On Fri, Dec 13, 2013 at 12:15 AM, Seb splu...@gmail.com wrote:
Hi,
I'm working on the design of a database for time series data collected
by a variety of meteorological sensors. Many sensors share the same
sampling scheme, but not all. I initially thought it would be a good
idea to have a
;
VACUUM
accounts= select pg_total_relation_size('myt');;
pg_total_relation_size
0
(1 row)
So what was the 65536 bytes left behind after standard vacuum?
Regards,
Jayadevan
Scott Marlowe-2 wrote
30 second vacuum lesson:
Thank you.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/vacuuming-doubt-tp5782828p5783057.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
is not an issue. Is
that correct?
Regards,
Jayadevan
hubert depesz lubaczewski-2 wrote
It looks like you're using csvlog. log_line_prefix is used only for
stderr/syslog logging.
Yes, that is right. Thank you.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/log-line-prefix-tp5778674p5778688.html
Sent from the
-
When a request message is received, we now fork() immediately. The child
process performs authentication of the request,
Now authentication is done by the Backend process and not by the daemon?
Regards,
Jayadevan
anyway. But which
setting?
Regards,
Jayadevan
or if they will waste
gigabytes of RAM.
Thank you
Alex
You may want to look at effective_cache_size also. May be quickly go
through
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and see what
http://pgfoundry.org/projects/pgtune/
says.
Jayadevan
Jeff Janes wrote
No. The checkpointer writes all data that was dirty as of a certain time
(the start of the checkpoint) regardless of how often it was used since
dirtied, and the background writer writes data that hasn't been used
recently, regardless of when it was first dirtied. Neither
On Thu, Nov 14, 2013 at 7:58 AM, Jayadevan maymala.jayade...@gmail.comwrote:
Jeff Janes wrote
No. The checkpointer writes all data that was dirty as of a certain time
(the start of the checkpoint) regardless of how often it was used since
dirtied, and the background writer writes data
Kevin Grittner-5 wrote
The checkpointer process is responsible for creating safe points
from which a recovery can begin; the background writer tries to
keep some pages available for re-use so that processes running
queries don't need to wait for page writes in order to have free
spots to use
Hi,
What are the real differences between the bgwriter and checkpointer
process? Both of them write data from the buffer to the data files, right?
Is it just a matter of 'when' they write?
Regards,
Jayadevan
,
Jayadevan
?
I can't find any links in postgresql.org or documentation pointing to files
like this.
Regards,
Jayadevan
Why don't you try adding layers one by one?
1) Ensure you can connect to PostgreSQL from psql client (on another
machine)
2) Configure pgbouncer
3) See if you can connect from psql pgbouncer PostgreSQL
Check the data in pgbpuncer and PostgreSQL (number of sessions, idle
connections etc). You
I have never used pgbouncer myself. But my guess is you have to look at the
Timeout parameters in the configuration file.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776481.html
Sent from the PostgreSQL - general mailing list archive
--
mynewschema, $user, public
(1 row)
I thought current_schemas and search_path will return the same set of
schemas (except that current_schema will show pg_catalog also, if we use
true). Shouldn't mynewschema appear in the output of select
current_schemas(true)?
Regards,
Jayadevan
OK. When I logged in as a user who had access to the schema, the output
from current_schemas and search_path were matching.
Thanks.
On Sun, Oct 27, 2013 at 9:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Jayadevan M maymala.jayade...@gmail.com writes:
I thought current_schemas and search_path
Alan Hodgson wrote
Well, yeah. The point was that you possibly could run it for a while to
catch
up without taking a new base backup if you desired. You should also keep
copies of it for PITR.
Something like this -
delayed replication
Jeff Janes wrote
I restore from my base backup plus WAL quite often. It is how I get a
fresh dev or test instance when I want one. (It is also how I have
confidence that everything is working well and that I know what I'm doing
should the time come to do a real restore). When that starts to
Alan Hodgson wrote
That's basically what warm standby's do, isn't it? As long as they keep
recovery open it should work.
A warn standby will be almost in sync with the primary, right? So recovery
to point-in-time (like 10 AM this morning) won't be possible. We need a
base, but it shouldn't be
? To avoid that,
what is the standard process followed - take a base backup every day or
once a week?
Regards,
Jayadevan
to test the configuration file for errors, after making
changes?
Regards,
Jayadevan
,
On Fri, Oct 18, 2013 at 1:12 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Jayadevan M maymala.jayade...@gmail.com writes:
Which is the quickest way to troubleshot the message
LOG: configuration file /postgresql.conf contains errors;
unaffected changes were applied ?
There should
Hi,
I was looking for options to make sure SQLs executed as part of functions
also get logged. Since this is a production system, I wanted to do it
without the EXPLAIN also written to the logs. May be that is not possible?
Regards,
Jayadevan
On Mon, Sep 30, 2013 at 5:08 PM, Albe Laurenz
, Amit Langote amitlangot...@gmail.comwrote:
On Wed, Sep 25, 2013 at 12:18 PM, Jayadevan M
maymala.jayade...@gmail.com wrote:
Hi all,
I am planning to use pgbadger for analyzing queries. Documentation for
pgbadger says Do not enable log_statement as their log format will not
be
parsed
, for example.
select sp_pg_refresh_alert_data(current_date);
But the SELECT and INSERT in the function are not getting logged. Is that
how PostgreSQL logging works, or I have missed something?
Regards,
Jayadevan
Could you please post EXPLAIN for that query?
How 'fat' are the temporary tables - just a couple of columns or really
wide?
On Mon, Sep 23, 2013 at 7:08 PM, Andrus kobrule...@hot.ee wrote:
Query
SELECT * FROM toode
WHERE toode in (SELECT toode FROM tempkaive)
OR toode in (SELECT toode
Regards,
Jayadevan
On Fri, Sep 20, 2013 at 3:19 PM, nikhilruikar nikhilrui...@gmail.comwrote:
Hi
I am planning to migrate oracle database to postgres. I need to know
if there are any plugins or tool with which I can use stored procedures
written in oracle schema for postgres with out
It should be possible to install the SW without initializing the cluster.
That way you may be in a better position to troubleshoot the issue.
Complete the installation, then use initdb to initialize a cluster. Have a
look at this url too -
Thank you for the pointers. I will try those suggestions. As I mentioned
later, resolving the query solved the problem for now.
Regards,
Jayadevan
On Thu, Sep 19, 2013 at 11:40 AM, Kevin Grittner-5 [via PostgreSQL]
ml-node+s1045698n5771567...@n5.nabble.com wrote:
Jayadevan [hidden
email
Hello,
When I upgraded from 9.2 to 9.3, I copied the postgresql.conf and
pg_hba.conf files form 9.2 installation and used those. Is that likely to
cause any issues? I did not see any significant parameter changes from 9.2
to 9.3. So far, it is running fine.
Regards,
Jayadevan
are being used (if I execute the SELECT in the function using a
valid value for the ip value.
Regards,
Jayadevan
Kevin Grittner-5 wrote
What is the longest you have let it run, in hours or minutes?
I let it run for about 10 minutes and killed it.
Kevin Grittner-5 wrote
By the way, IMMUTABLE has to be wrong here, since the results
depend on the state of the database. STABLE is likely the right
Kevin Grittner-5 wrote
We already had this. I was asking for you to get EXPLAIN ANALYZE
output for a run of the SELECT statement inside the geoip_city()
function.
Merge Join (cost=9268.34..26193.41 rows=6282 width=24) (actual
time=892.188..892.190 rows=1 loops=1)
Merge Cond: (l.id =
Rewriting the query in the function like this solved the issue (this is how
it was in the SQL at
https://github.com/tvondra/geoip/blob/master/sql/geoip--0.1.0.sql)
explain analyze
SELECT l.id, l.country, l.region, l.city FROM blocks b JOIN locations l ON
(b.location_id = l.id)
WHERE
Hello all,
Elephants Never Forget sounds like a good idea. It refers to reliability
of the database (from a transaction perspective) and ability to recover
lost data.
http://www.scientificamerican.com/article.cfm?id=elephants-never-forget
Regards,
Jayadevan
On Sun, Sep 8, 2013 at 9:20 PM, Erik
Alban Hertroys-4 wrote
How is Pentaho an OLAP tool? Aren't you mixing up a few things?
We already use Pentaho for ETL, so I'm a bit familiar with it. Why do you
consider it suitable for managing an OLAP database?
How would Pentaho manage cube rollup triggers, business models, dimensions
and
Hello all,
Is the release date for PostgreSQL 9.3 production decided? We are going
live in a couple of weeks with a portal and if possible, would like to go
with 9.3, Materialized Views being the key feature that will add value.
Regards,
Jayadevan
Hi,
Thanks. So we are close to the tentative release date. Good.
Regards,
Jayadevan
On Mon, Aug 19, 2013 at 10:16 AM, Sandro CAZZANIGA
cazzaniga.san...@gmail.com wrote:
Le 19/08/2013 06:38, Jayadevan M a écrit :
Hello all,
Is the release date for PostgreSQL 9.3 production decided? We
Hi,
Having a look at the PostgreSQL log may help.
http://stackoverflow.com/questions/71/how-to-log-postgres-sql-queries
You could also try logging in via psql on the database host itself, to
ensure it is not a network issue.
Regards,
Jayadevan
On Wed, Aug 14, 2013 at 2:21 AM, Barth Weishoff
Hi,
In case you are not keen on getting the latest and really accurate
counts/size, you could just refer the views readily available -
http://stackoverflow.com/questions/2596670/how-do-you-find-the-row-count-for-all-your-tables-in-postgres
You won't get the updatetime, though.
Regards,
Jayadevan
Hi,
From Oracle to PostgreSQL, you could have a look at Goldengate. It does not
support PostgreSQL as the source database.
Regards,
Jayadevan
On Wed, Aug 7, 2013 at 1:54 PM, BOUVARD Aurélien
aurelien.bouv...@supinfo.com wrote:
Hi all,
** **
My compagny would like to configure
Hi,
System tables, views and most of the metadata can be retrieved from these
views -
http://www.postgresql.org/docs/9.2/static/information-schema.html
Regards,
Jayadevan
On Sun, Aug 4, 2013 at 2:48 PM, sachin kotwal kotsac...@gmail.com wrote:
Hello
While migrating small application from
Hi,
I have postgresql streaming replication set up. I forgot to add an entry for
trigger_file in recovery.conf. So I added that entry and did a pg_ctl reload.
Is there a way to confirm that the entry has been read by the server? Any
view/function?
Regards,
Jayadevan
DISCLAIMER
to recovery.conf. How can I make slave 'accept' that change?
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
. Apologies.
I tried restarting the standby node and it worked.
Thanks a lot,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail
)
UNION ALL
SELECT n+10 FROM t WHERE n 50
)
select count(*), t.n from m, t where mark t.n group by t.n;
I meant 'fast', not 'fat. Sorry for the typo.
You got it right. The query gets the data exactly as I wanted it. Thanks a lot.
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail
,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly contact
the sender and destroy all copies of the original
isn't much since json
is
an already serialized format).
OK. That explains it. I was wondering why we have quite a few functions under
pg_catalog and just a few in the documentation. Thank you.
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended only
Hi,
I have PostgreSQL 9.2.1. I can see a few json functions under pg_catalog,
json_send, for example. But I can't find any documentation. Am I missing
something?
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended only
for the person to whom
quite a few cases - such as
trying out the application on PostgreSQL before really cutting over from an
Oracle database, may be running reports off PostgreSQL and so on.
Regards,
Jayadevan
://linux.dell.com/dvdstore/
It can generate testdata with a specific scale and it works well with Postgres.
Thank you. Will try these.
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended
only for the person to whom it is addressed and may contain
not simple.
Anything similar - the typical warehouse/customer/order tables or
emp/dept/project ?
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended
only for the person to whom it is addressed and may contain confidential and/or
privileged material
- in this
case the slave is almost uptodate
If I set up a slave using the archived WAls and set hot_standby on in the
slave, will I be able to read from the slave?
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended
only for the person to whom
). This url might also help
-
http://www.postgresql.org/docs/9.1/static/populate.html
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is intended
only for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have
option.
http://www.postgresql.org/docs/current/static/explicit-locking.html
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received
of these features will become part of the
'core' soon.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error
in the development/test environment.
http://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_intro.htm
Won't something like this be useful in PostgreSQL? It will let us mimic
the production environment load and analyze it better.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any
. That is what we did. We used ora2pg for database migration and
orafce (http://pgfoundry.org/projects/orafce/) to minimize code changes.
Since we did not have many procedures/packages it worked very well.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment
/content/postgresql/InsideBufferCache.pdf
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact
is not desirable.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all
Thank you. We are working on an Oracle to PostgreSQL migration project.
BLOB columns got converted to BYTEA in PostgreSQL and we ran into problems.
We used this to convert the data type to OID. Thank you.
--
View this message in context:
been inserted.
Switching to file storage will mean quite a bit of changes at the code
level, and a lot of testing of the products that runs fine on Oracle now.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom
in (select min(id) from myt group by
loc_title) order by loc_title;
id | loc_title | loc_value | loc_unit
+---+---+--
1 | AA|80 | 10
3 | BB|80 | 10
(2 rows)
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any
checked the log file for
errors,corrected the data issues in the source table (Oracle) and it
finished the load without issues.
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential
' and log_time '20110818')
and it shows
.AND ( CUSINDINF.MEMDOB )= ($4)
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you
to debug5 in postgresql.conf
for all logging options. But what is the 'correct' approach?
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you
. It is not a good idea to try and read pdf files in Kindle.
You have to send the pdf file to kindleusername@free.kindle.com
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential
it starts;
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all
--
postgres
(1 row)
postgres=# show hba_file;
hba_file
---
/usr/local/pgsql/data/pg_hba.conf
(1 row)
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain
/functions-admin.html
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy
about what goes into WAL tells me that the permanent table data
will be replicated all right even if the temp tables are not logged. Is
that right?
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed
, such as session statues, application logs, etc.
One doubt - if the tables are 'unlogged' , will the DMLs against these
still be replicated to a slave?
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom
an insert into an 'unlogged' table, what happens to that?
Will that be replicated in the slave (using PostgreSQL's inbuilt
replication)?
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain
,'-',''),'
','') = '1333';
name
13-333-333
(1 row)
postgres=# select * from myt where translate(translate(name,'-',''),'
','') = '12344';
name
-
12 3-44
(1 row)
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only
1 - 100 of 132 matches
Mail list logo