Hi guys,
I need a function ( PL/PGSQL ) to perform a deletion of some BLOBS...
I have four tables:
*- original_table1_b =* Original table, where the BLOBS are
> *- table1_n_b =* Table where everything related to the BLOBS is stored
> (file_id, account_id, note_id, etc)
> *- table2_y_b =* Table B
>
>
> I'd suggest you setup a test environment with some unimportant data on a
> non-production machine and try it yourself.
>
>
>
> David J.
>
>
>
>
Thanks.. but if I'm asking the list that's because I'm already testing it
and it's not working... ;)
Patrick
>
>
>>
> I maybe be missing it, but I see no LIMIT in the function.
>
> I do see OFFSET and it looks backwards to me?:
>
> || $1 ||' offset '||
>
> https://www.postgresql.org/docs/9.5/static/sql-select.html
>
> LIMIT Clause
>
> The LIMIT clause consists of two independent sub-clauses:
>
> LIMIT { c
2016-06-03 2:10 GMT+12:00 David G. Johnston :
> On Thu, Jun 2, 2016 at 1:04 AM, Patrick Baker
> wrote:
>
>>
>>>> It's all working, except the LIMIT... if possible can you please give
>> me an example of that LIMIT in some of those queries?
>>
>
>
>
>>
>
> Why are you joining to table3_nb?
> You do not use any fields from it.
>
> How do you know what data in table1_n_b to get?
> I see this grabbing the same information over and over again.
SELECT * INTO table3_n_b FROM (
SELECT account_id, note_id, file_id FROM
(
I did:
CREATE or REPLACE FUNCTION function_1_data()
RETURNS INTEGER AS $$
declare
row record;
BEGIN
-- copying the data to the backup table (not the blobs)
FOR row IN EXECUTE '
SELECT
t1.file_id
FROM
table1_n_b t1
Hi guys,
-
The function works... All the data is updated as expected. However, when
I call the function for the second time, it touches the rows that had
already been touched by the previous call
-
It triplicate ( LIMIT 3 ) the records.
*Question:*
How can I make the fun
2016-06-03 15:50 GMT+12:00 David G. Johnston :
> On Thu, Jun 2, 2016 at 11:37 PM, Patrick Baker
> wrote:
>
>>
>> How can I make the function to gets the next 3 rows and not use the same
>> rows that have been used before?
>>
> WHERE migrated = 0
>
>
>
>
>
> -- Creating the backup table with the essential data
> INSERT INTO table2 (row.note_id, row.size, row.file_id, row.full_path)
>
> .
>
> Still not seeing what the JOIN to table3 t3 gets you?
>
> Any way the function works.
>
>
I changed the function to use row.note_id, row.size, etc... t
Hi there,
I've got the following query:
>
> SELECT COUNT(DISTINCT j0_.id) AS sclr10
> FROM customers j0_
> WHERE ((LOWER(j0_.name_first) LIKE '%some%'
> OR LOWER(j0_.name_last) LIKE '%some%')
>AND j0_.id = 5)
> AND j0_.id = 5
The query is taking ages to run.
I read about wild
>
>
>
> Maybe Lucas Possamai can help. He seems to be a little bit further along
> in this exercise.
>
> I'm too tired to care at the moment. And I haven't had much practical
> work here anyway.
>
> David J.
>
>
>
>
I subscribed to the list today, so don't have the old emails
I had a look o
11 matches
Mail list logo
