Reputation
8,942
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~450k people reached

Jul
14
comment Multiple table relationship for different scenarios!
Please show your ERD - it describes the situation the best.
Jul
14
comment MySQL : How to restore mysql dump (.sql) ignoring DROP TABLE statement?
What about the CREATE TABLE statements? Furthermore, grep -v ... 1.sql does just the same, no need for cat.
Jul
13
comment How to use variables in a PL/pgSQL function with dynamic queries?
What is object_id()? And tempdb? Also, quote_ident() is necessary only for database object names, it would throw an error if applied to column values. The second example with the INSERT does not need a dynamic query at all. BTW, which PostgreSQL version do you use?
Jul
13
comment Building a restaurant database
What is ISA? And what do you mean by 'readable'?
Jul
13
comment Does reporting webservice url contain the function that helps to export the report to the client version?
In broader: please include here the steps/elements of the solution that helps the OP. You might have the idea later to move your page to somewhere else - in this case the link will 'rot', making this answer useless.
Jul
13
comment Oracle Performance on 2 servers
If I see it correctly, the timing involves transporting data over to the client. Can it be that this is the only source of the time difference?
Jul
13
comment How to prevent multiple queries in this case?
As an aside, it's not a very wise idea to name tables with keywords.
Jul
10
comment SQL Join Field and Content
Could you then remove the references to HTML? And possibly add an example output table.
Jul
10
comment SQL Join Field and Content
Are you sure a SQL join will produce HTML for you?
Jul
10
comment Why postgresql pg_dump exports a view as a table?
Is it a materialized view?
Jul
10
comment GRANT USAGE on all schemas in a database? postgres
@a_horse_with_no_name thinking about it, I see currently no reason why it could not be done.
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
According to postgresql.org/docs/8.4/static/sql-createtable.html, the IF NOT EXISTS syntax didn't exist in 8.4 (appeared in 9.1)
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Just out of curiosity, why cannot you upgrade?
Jul
10
comment Implementing a function written for Postgres 9.4 in Postgres 8.4
Well, the format( is missing from your post - otherwise, you have to concatenate and quote with quote_ident(). But the best suggestion would be upgrading ;)
Jul
10
comment Where is the default postgres user path environment set?
I'm voting to close this question as off-topic because it's a sysadmin problem, thus a topic for SU
Jul
10
comment Update one column based on count of records of grouped value in another column
When providing table designs and sample data, you should include actual CREATE TABLE and INSERT statements, so that anyone trying to answer could easily reproduce your problem.
Jul
9
comment Oracle's (+) notation within function
Do you have any reason for not using the standard syntax?
Jul
9
comment Does running pg_dump on live db produce consistent backups?
Your statements are either indicating a serious bug (did you file a bug report?), a serious bug in the way you dump your database or some misunderstanding. Lacking any facts one cannot decide among these.
Jul
9
comment How to find similar (but different) names with the same soundex value?
@MohamedAshrafAliB it's not a variable but a mandatory table alias for a subquery.
Jul
9
comment How to find similar (but different) names with the same soundex value?
Please give some examples that you'd like to find. How similar is similar?