I apologize for asking, what I suspect will turn out to be a newbie
question, but I have managed to get myself quite confused on this.
I am defining a view as follows
CREATE OR REPLACE view purchase_view as
select
project.proj_no ,
qty ,
mfg_part.mfg_part_no ,
m
Sorry, I got the list address wrong the first time, and when I corected it,
I forget to fix the subject line.
I apologize for asking, what I suspect will turn out to be a newbie
question, but I have managed to get myself quite confused on this.
I am defining a view as follows
CREATE OR REPLACE
On 8/10/19 1:57 PM, stan wrote:
Sorry, I got the list address wrong the first time, and when I corected it,
I forget to fix the subject line.
I apologize for asking, what I suspect will turn out to be a newbie
question, but I have managed to get myself quite confused on this.
I am defining a vi
>
> I'd look here:
>
> SELECT
> name
> FROM
> vendor
> WHERE
> bom_item.vendor_key =
> (
> SELECT
> vendor_key
> FROM
>
>ERROR: more than one row returned by a subquery used as an expression
Well, we really do not have any insight as to the contents of your data, but
have you thought about using *SELECT DISTINCT i*n your subquerys?
On Sat, Aug 10, 2019 at 2:53 PM stan wrote:
> I apologize for asking, what I sus
>ERROR: more than one row returned by a subquery used as an expression
Without knowledge as to the contents of your data, the best I can suggest is
to use *SELECT DISTINCT* in your subqueries.
On Sat, Aug 10, 2019 at 3:42 PM Rob Sargent wrote:
>
>
> I'd look here:
>
> SELECT
> name
> FROM
> ve
On Saturday, August 10, 2019, stan wrote:
> Sorry, I got the list address wrong the first time, and when I corected it,
> I forget to fix the subject line.
>
>
This subject line isn’t materially better...subjects should reflect the
technical content of the message, not its sender.
David J.
Hi Adrian,
Thanks for the response.
> Yes, but you will some code via client or function that batches the
> inserts for you.
Could you please elaborate a bit on how EXP 1 could be performed such that
it uses bulk inserts?
Best,
-SB
On Fri, Aug 9, 2019 at 7:26 PM Adrian Klaver
wrote:
> On 8/9
> On Aug 10, 2019, at 8:47 PM, Souvik Bhattacherjee wrote:
>
> Hi Adrian,
>
> Thanks for the response.
>
> > Yes, but you will some code via client or function that batches the
> > inserts for you.
>
> Could you please elaborate a bit on how EXP 1 could be performed such that it
> uses bul
> Does this appeal to you:
> COPY (SELECT * FROM relation) TO ... (
https://www.postgresql.org/docs/10/sql-copy.html)
Not sure if COPY can be used to transfer data between tables.
On Sat, Aug 10, 2019 at 11:01 PM Rob Sargent wrote:
>
>
> On Aug 10, 2019, at 8:47 PM, Souvik Bhattacherjee
> wrot
Hello,
On Sat, 2019-08-10 at 14:53 -0400, stan wrote:
> I apologize for asking, what I suspect will turn out to be a newbie
> question, but I have managed to get myself quite confused on this.
>
> I am defining a view as follows
>
>
> CREATE OR REPLACE view purchase_view as
> select
> p
11 matches
Mail list logo
