[SQL] sql basic question

[Antonio Parrotta]

Hi All,

I have this table:
LABEL ID  Distance SIDE
"15"; 119006;  0.10975569030617;1
"14"; 64054;0.118448307450912;  0
"16"; 64055;0.176240407317772;  0
"20"; 64057;0.39363711745035;0
"19"; 64056;0.41205442839764;1
"24"; 119007;  0.59758734628752;0

What I want to achieve is a result table with min and max distance for each
side, limiting to 2 (basically the boundaries of each SIDE)

so the result should be:
LABELID  Distance SIDE
"15"; 119006;  0.10975569030617;1
"19"; 64056;0.41205442839764;1
"14"; 64054;0.118448307450912;  0
"24"; 119007;  0.59758734628752;0


Thanks a lot


- Antonio
y

Re: [SQL] sql basic question

[Anton Gavazuk]

Do the child Select min, max from... Group by side

Then you can do whatever is required...

Thanks,
Anton

On Dec 28, 2012, at 12:23, Antonio Parrotta 
wrote:

Hi All,

I have this table:
LABEL ID  Distance SIDE
"15"; 119006;  0.10975569030617;1
"14"; 64054;0.118448307450912;  0
"16"; 64055;0.176240407317772;  0
"20"; 64057;0.39363711745035;0
"19"; 64056;0.41205442839764;1
"24"; 119007;  0.59758734628752;0

What I want to achieve is a result table with min and max distance for each
side, limiting to 2 (basically the boundaries of each SIDE)

so the result should be:
LABELID  Distance SIDE
"15"; 119006;  0.10975569030617;1
"19"; 64056;0.41205442839764;1
"14"; 64054;0.118448307450912;  0
"24"; 119007;  0.59758734628752;0


Thanks a lot


- Antonio
y

Re: [SQL] sql basic question

[Antonio Parrotta]

Hi Anton,

I need column LABEL  and ID as well. By grouping on SIDE these column
cannot be included in the query.

Thanks

- Antonio


On 28 December 2012 12:38, Anton Gavazuk  wrote:

> Do the child Select min, max from... Group by side
>
> Then you can do whatever is required...
>
> Thanks,
> Anton
>
> On Dec 28, 2012, at 12:23, Antonio Parrotta 
> wrote:
>
> Hi All,
>
> I have this table:
> LABEL ID  Distance SIDE
> "15"; 119006;  0.10975569030617;1
> "14"; 64054;0.118448307450912;  0
> "16"; 64055;0.176240407317772;  0
> "20"; 64057;0.39363711745035;0
> "19"; 64056;0.41205442839764;1
> "24"; 119007;  0.59758734628752;0
>
> What I want to achieve is a result table with min and max distance for
> each side, limiting to 2 (basically the boundaries of each SIDE)
>
> so the result should be:
> LABELID  Distance SIDE
> "15"; 119006;  0.10975569030617;1
> "19"; 64056;0.41205442839764;1
> "14"; 64054;0.118448307450912;  0
> "24"; 119007;  0.59758734628752;0
>
>
> Thanks a lot
>
>
> - Antonio
> y
>
>

Re: [SQL] sql basic question

[Anton Gavazuk]

Antonio,

 but then you can do join between minmax select and source table by
distance and get required columns...

Thanks,
Anton

On Dec 28, 2012, at 12:43, Antonio Parrotta 
wrote:

Hi Anton,

I need column LABEL  and ID as well. By grouping on SIDE these column
cannot be included in the query.

Thanks

- Antonio


On 28 December 2012 12:38, Anton Gavazuk  wrote:

> Do the child Select min, max from... Group by side
>
> Then you can do whatever is required...
>
> Thanks,
> Anton
>
> On Dec 28, 2012, at 12:23, Antonio Parrotta 
> wrote:
>
> Hi All,
>
> I have this table:
> LABEL ID  Distance SIDE
> "15"; 119006;  0.10975569030617;1
> "14"; 64054;0.118448307450912;  0
> "16"; 64055;0.176240407317772;  0
> "20"; 64057;0.39363711745035;0
> "19"; 64056;0.41205442839764;1
> "24"; 119007;  0.59758734628752;0
>
> What I want to achieve is a result table with min and max distance for
> each side, limiting to 2 (basically the boundaries of each SIDE)
>
> so the result should be:
> LABELID  Distance SIDE
> "15"; 119006;  0.10975569030617;1
> "19"; 64056;0.41205442839764;1
> "14"; 64054;0.118448307450912;  0
> "24"; 119007;  0.59758734628752;0
>
>
> Thanks a lot
>
>
> - Antonio
> y
>
>

Re: [SQL] sql basic question

[Antonio Parrotta]

Hi Andreas, Anton,

I did some test and both queries didn't worked. Maybe I was not clear with
the example provided.
My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and
-3.
Example provided is a very small subset.

*Andrea's *query is failing because it is getting only distinct SIDEs. The
query returns just 14 rows.

*Anton's *one because it is joining on distance so merges records without a
relation (I have many rows with a distance of 0 for example). I need to
have a join on IDs instead

Thanks

- Antonio


On 28 December 2012 13:00, Andreas Kretschmer wrote:

> >
> > so the result should be:
> > LABELID  Distance SIDE
> > "15"; 119006;  0.10975569030617;1
> > "19"; 64056;0.41205442839764;1
> > "14"; 64054;0.118448307450912;  0
> > "24"; 119007;  0.59758734628752;0
> >
> >
>
>
>
> test=*# select * from foo;
>  label |   id   | distance  | side
> ---++---+--
> 15 | 119006 |  0.10975569030617 |1
> 14 |  64054 | 0.118448307450912 |0
> 16 |  64055 | 0.176240407317772 |0
> 20 |  64057 |  0.39363711745035 |0
> 19 |  64056 |  0.41205442839764 |1
> 24 | 119007 |  0.59758734628752 |0
> (6 rows)
>
> test=*# select * from (select distinct on (side) label, id, distance, side
> from
> foo order by side, distance) a union all (select distinct on (side) label,
> id,
> distance, side from foo order by side, distance desc) order by side desc,
> label;
>  label |   id   | distance  | side
> ---++---+--
> 15 | 119006 |  0.10975569030617 |1
> 19 |  64056 |  0.41205442839764 |1
> 14 |  64054 | 0.118448307450912 |0
> 24 | 119007 |  0.59758734628752 |0
> (4 rows)
>
>
> HTH, Andreas
>

Fwd: Re: [SQL] sql basic question

[Andreas Kretschmer]

sorry, only a private replay and not to the list

-- Ursprüngliche Nachricht --
Von: Andreas Kretschmer 
An: Antonio Parrotta 
Datum: 28. Dezember 2012 um 15:19
Betreff: Re: [SQL] sql basic question
Hi,

your question was: "What I want to achieve is a result table with min and max
distance for each side".

Okay, with SIDE in 0,1,-1,2,-2,3,-3 there are exactly 14 possible values for
each SIDE and Min/Max.


If this is wrong, describe your problem better.




Antonio Parrotta  hat am 28. Dezember 2012 um 15:12
geschrieben:
> Hi Andreas, Anton,
>
> I did some test and both queries didn't worked. Maybe I was not clear with
> the example provided.
> My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and
> -3.
> Example provided is a very small subset.
>
> *Andrea's *query is failing because it is getting only distinct SIDEs. The
> query returns just 14 rows.
>
> *Anton's *one because it is joining on distance so merges records without a
> relation (I have many rows with a distance of 0 for example). I need to
> have a join on IDs instead
>
> Thanks
>
> - Antonio
>
>
> On 28 December 2012 13:00, Andreas Kretschmer wrote:
>
> > >
> > > so the result should be:
> > > LABELID  Distance SIDE
> > > "15"; 119006;  0.10975569030617;1
> > > "19"; 64056;0.41205442839764;1
> > > "14"; 64054;0.118448307450912;  0
> > > "24"; 119007;  0.59758734628752;0
> > >
> > >
> >
> >
> >
> > test=*# select * from foo;
> >  label |   id   | distance  | side
> > ---++---+--
> > 15 | 119006 |  0.10975569030617 |1
> > 14 |  64054 | 0.118448307450912 |0
> > 16 |  64055 | 0.176240407317772 |0
> > 20 |  64057 |  0.39363711745035 |0
> > 19 |  64056 |  0.41205442839764 |1
> > 24 | 119007 |  0.59758734628752 |0
> > (6 rows)
> >
> > test=*# select * from (select distinct on (side) label, id, distance, side
> > from
> > foo order by side, distance) a union all (select distinct on (side) label,
> > id,
> > distance, side from foo order by side, distance desc) order by side desc,
> > label;
> >  label |   id   | distance  | side
> > ---++---+--
> > 15 | 119006 |  0.10975569030617 |1
> > 19 |  64056 |  0.41205442839764 |1
> > 14 |  64054 | 0.118448307450912 |0
> > 24 | 119007 |  0.59758734628752 |0
> > (4 rows)
> >
> >
> > HTH, Andreas
> >
> Hi Andreas, Anton,
>
> I did some test and both queries didn't worked. Maybe I was not clear with the
> example provided.
> My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and -3.
> Example provided is a very small subset.
>
> Andrea's query is failing because it is getting only distinct SIDEs. The query
>  returns just 14 rows.
>
> Anton's one because it is joining on distance so merges records without a
> relation (I have many rows with a distance of 0 for example). I need to have a
> join on IDs instead
>
> Thanks
>
> - Antonio
>
>
> On 28 December 2012 13:00, Andreas Kretschmer  wrote:
> >   >
> >   > so the result should be:
> >   > LABELID  Distance SIDE
> >   > "15"; 119006;  0.10975569030617;1
> >   > "19"; 64056;0.41205442839764;1
> >   > "14"; 64054;0.118448307450912;  0
> >   > "24"; 119007;  0.59758734628752;0
> >   >
> >   >
> >
> >
> >
> >   test=*# select * from foo;
> >label |   id   | distance  | side
> >   ---++---+--
> >   15 | 119006 |  0.10975569030617 |1
> >   14 |  64054 | 0.118448307450912 |0
> >   16 |  64055 | 0.176240407317772 |0
> >   20 |  64057 |  0.39363711745035 |0
> >   19 |  64056 |  0.41205442839764 |1
> >   24 | 119007 |  0.59758734628752 |0
> >   (6 rows)
> >
> >   test=*# select * from (select distinct on (side) label, id, distance, side
> > from
> >   foo order by side, distance) a union all (select distinct on (side) label,
> > id,
> >   distance, side from foo order by side, distance desc) order by side desc,
> > label;
> >label |   id   | distance  | side
> >   ---++---+--
> >   15 | 119006 |  0.10975569030617 |1
> >   19 |  64056 |  0.41205442839764 |1
> >   14 |  64054 | 0.118448307450912 |0
> >   24 | 119007 |  0.59758734628752 |0
> >   (4 rows)
> >
> >
> >   HTH, Andreas


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] sql basic question

[Antonio Parrotta]

Hello Andreas,

apologize for the misunderstanding. Hope to clarify now.  For each ID I
want a min and max for each SIDE. I have about 160K records like this:

  label |   id   | distance | side
 ---++---+--
 15 | 119006 |  0.10975569030617 |1  *m
 14 | 119006 |  0.11844830745091 |0  *m
 16 | 119006 |  0.17624040731777 |0
 20 | 119006 |  0.39363711745035 |0   *M
 19 | 119006 |  0.41205442839764 |1   *M
 24 | 119006 |  0.35455674575682 |1
 12 | 23434   |  0.88764543364566 |0  *M
 31 | 23434   |  0.53456343463466 |0  *m
 33 | 23434   |  0.23235478697988 |1  *m/M
 01 | 23434   |  0.59758734628752 |0
 14 | 129007 |  0.63454675634756 |0   *m
 13 | 129007 |  0.22345364656788 |1   *m
 11 | 129007 |  0.86787897897689 |1   *M
 12 | 129007 |  0.34678678978089 |1
 19 | 129007 |  0.97897897897654 |0   *M
(*M maximum for that ID and SIDE, *m minimum for that ID and SIDE)

result should be:
 14 | 119006 |  0.11844830745091 |0 *m
 20 | 119006 |  0.39363711745035 |0 *M
 15 | 119006 |  0.10975569030617 |1 *m
 19 | 119006 |  0.41205442839764 |1 *M
 31 | 23434   |  0.53456343463466 |0 *m
 12 | 23434   |  0.88764543364566 |0 *M
 33 | 23434   |  0.23235478697988 |1 *m/M
 14 | 129007 |  0.63454675634756 |0 *m
 19 | 129007 |  0.97897897897654 |0 *M
 13 | 129007 |  0.22345364656788 |1 *m
 11 | 129007 |  0.86787897897689 |1  *M

thanks


- Antonio


On 28 December 2012 15:19, Andreas Kretschmer wrote:

> Hi,
>
> your question was: "What I want to achieve is a result table with min and
> max
> distance for each side".
>
> Okay, with SIDE in 0,1,-1,2,-2,3,-3 there are exactly 14 possible values
> for
> each SIDE and Min/Max.
>
>
> If this is wrong, describe your problem better.
>
>
>
>
> Antonio Parrotta  hat am 28. Dezember 2012 um
> 15:12
> geschrieben:
> > Hi Andreas, Anton,
> >
> > I did some test and both queries didn't worked. Maybe I was not clear
> with
> > the example provided.
> > My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and
> > -3.
> > Example provided is a very small subset.
> >
> > *Andrea's *query is failing because it is getting only distinct SIDEs.
> The
> > query returns just 14 rows.
> >
> > *Anton's *one because it is joining on distance so merges records
> without a
> > relation (I have many rows with a distance of 0 for example). I need to
> > have a join on IDs instead
> >
> > Thanks
> >
> > - Antonio
> >
> >
> > On 28 December 2012 13:00, Andreas Kretschmer  >wrote:
> >
> > > >
> > > > so the result should be:
> > > > LABELID  Distance SIDE
> > > > "15"; 119006;  0.10975569030617;1
> > > > "19"; 64056;0.41205442839764;1
> > > > "14"; 64054;0.118448307450912;  0
> > > > "24"; 119007;  0.59758734628752;0
> > > >
> > > >
> > >
> > >
> > >
> > > test=*# select * from foo;
> > >  label |   id   | distance  | side
> > > ---++---+--
> > > 15 | 119006 |  0.10975569030617 |1
> > > 14 |  64054 | 0.118448307450912 |0
> > > 16 |  64055 | 0.176240407317772 |0
> > > 20 |  64057 |  0.39363711745035 |0
> > > 19 |  64056 |  0.41205442839764 |1
> > > 24 | 119007 |  0.59758734628752 |0
> > > (6 rows)
> > >
> > > test=*# select * from (select distinct on (side) label, id, distance,
> side
> > > from
> > > foo order by side, distance) a union all (select distinct on (side)
> label,
> > > id,
> > > distance, side from foo order by side, distance desc) order by side
> desc,
> > > label;
> > >  label |   id   | distance  | side
> > > ---++---+--
> > > 15 | 119006 |  0.10975569030617 |1
> > > 19 |  64056 |  0.41205442839764 |1
> > > 14 |  64054 | 0.118448307450912 |0
> > > 24 | 119007 |  0.59758734628752 |0
> > > (4 rows)
> > >
> > >
> > > HTH, Andreas
> > >
> > Hi Andreas, Anton,
> >
> > I did some test and both queries didn't worked. Maybe I was not clear
> with the
> > example provided.
> > My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3
> and -3.
> > Example provided is a very small subset.
> >
> > Andrea's query is failing because it is getting only distinct SIDEs. The
> query
> >  returns just 14 rows.
> >
> > Anton's one because it is joining on distance so merges records without a
> > relation (I have many rows with a distance of 0 for example). I need to
> have a
> > join on IDs instead
> >
> > Thanks
> >
> > - Antonio
> >
> >
> > On 28 December 2012 13:00, Andreas Kretschmer 
> wrote:
> > >   >
> > >   > so the result should be:
> > >   > LABELID  Distance SIDE
> > >   > "15"; 1

Re: [SQL] sql basic question

[Andreas Kretschmer]

Maybe something like:

test=*# select * from foo;
 label |   id   | distance | side
---++--+--
15 | 119006 | 0.10975569030617 |1
14 | 119006 | 0.11844830745091 |0
16 | 119006 | 0.17624040731777 |0
20 | 119006 | 0.39363711745035 |0
19 | 119006 | 0.41205442839764 |1
24 | 119006 | 0.35455674575682 |1
12 |  23434 | 0.88764543364566 |0
31 |  23434 | 0.53456343463466 |0
33 |  23434 | 0.23235478697988 |1
 1 |  23434 | 0.59758734628752 |0
14 | 129007 | 0.63454675634756 |0
13 | 129007 | 0.22345364656788 |1
11 | 129007 | 0.86787897897689 |1
12 | 129007 | 0.34678678978089 |1
19 | 129007 | 0.97897897897654 |0
(15 rows)

test=*# select * from (select distinct on (id, side) label, id, distance, side,
'm'::text as min_max from foo order by id, side, distance) a union all (select
distinct on (id, side) label, id, distance, side, 'M' as min_max from foo order
by id, side, distance desc);
 label |   id   | distance | side | min_max
---++--+--+-
31 |  23434 | 0.53456343463466 |0 | m
33 |  23434 | 0.23235478697988 |1 | m
14 | 119006 | 0.11844830745091 |0 | m
15 | 119006 | 0.10975569030617 |1 | m
14 | 129007 | 0.63454675634756 |0 | m
13 | 129007 | 0.22345364656788 |1 | m
12 |  23434 | 0.88764543364566 |0 | M
33 |  23434 | 0.23235478697988 |1 | M
20 | 119006 | 0.39363711745035 |0 | M
19 | 119006 | 0.41205442839764 |1 | M
19 | 129007 | 0.97897897897654 |0 | M
11 | 129007 | 0.86787897897689 |1 | M
(12 rows)


Better?


Antonio Parrotta  hat am 28. Dezember 2012 um 15:52
geschrieben:
> Hello Andreas,
>
> apologize for the misunderstanding. Hope to clarify now.  For each ID I
> want a min and max for each SIDE. I have about 160K records like this:
>
>   label |   id   | distance | side
>  ---++---+--
>  15 | 119006 |  0.10975569030617 |1  *m
>  14 | 119006 |  0.11844830745091 |0  *m
>  16 | 119006 |  0.17624040731777 |0
>  20 | 119006 |  0.39363711745035 |0   *M
>  19 | 119006 |  0.41205442839764 |1   *M
>  24 | 119006 |  0.35455674575682 |1
>  12 | 23434   |  0.88764543364566 |0  *M
>  31 | 23434   |  0.53456343463466 |0  *m
>  33 | 23434   |  0.23235478697988 |1  *m/M
>  01 | 23434   |  0.59758734628752 |0
>  14 | 129007 |  0.63454675634756 |0   *m
>  13 | 129007 |  0.22345364656788 |1   *m
>  11 | 129007 |  0.86787897897689 |1   *M
>  12 | 129007 |  0.34678678978089 |1
>  19 | 129007 |  0.97897897897654 |0   *M
> (*M maximum for that ID and SIDE, *m minimum for that ID and SIDE)
>
> result should be:
>  14 | 119006 |  0.11844830745091 |0 *m
>  20 | 119006 |  0.39363711745035 |0 *M
>  15 | 119006 |  0.10975569030617 |1 *m
>  19 | 119006 |  0.41205442839764 |1 *M
>  31 | 23434   |  0.53456343463466 |0 *m
>  12 | 23434   |  0.88764543364566 |0 *M
>  33 | 23434   |  0.23235478697988 |1 *m/M
>  14 | 129007 |  0.63454675634756 |0 *m
>  19 | 129007 |  0.97897897897654 |0 *M
>  13 | 129007 |  0.22345364656788 |1 *m
>  11 | 129007 |  0.86787897897689 |1  *M
>
> thanks
>
>
> - Antonio
>
>
> On 28 December 2012 15:19, Andreas Kretschmer wrote:
>
> > Hi,
> >
> > your question was: "What I want to achieve is a result table with min and
> > max
> > distance for each side".
> >
> > Okay, with SIDE in 0,1,-1,2,-2,3,-3 there are exactly 14 possible values
> > for
> > each SIDE and Min/Max.
> >
> >
> > If this is wrong, describe your problem better.
> >
> >
> >
> >
> > Antonio Parrotta  hat am 28. Dezember 2012 um
> > 15:12
> > geschrieben:
> > > Hi Andreas, Anton,
> > >
> > > I did some test and both queries didn't worked. Maybe I was not clear
> > with
> > > the example provided.
> > > My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and
> > > -3.
> > > Example provided is a very small subset.
> > >
> > > *Andrea's *query is failing because it is getting only distinct SIDEs.
> > The
> > > query returns just 14 rows.
> > >
> > > *Anton's *one because it is joining on distance so merges records
> > without a
> > > relation (I have many rows with a distance of 0 for example). I need to
> > > have a join on IDs instead
> > >
> > > Thanks
> > >
> > > - Antonio
> > >
> > >
> > > On 28 December 2012 13:00, Andreas Kretschmer  > >wrote:
> > >
> > > > >
> > > > > so the result should be:
> > > > > LABELID  Distance SIDE
> > > > > "15"; 119006;  0.10975569030617;1
> > > > > "19"; 64056;0.41205442839764;1
> > > > > "14"; 64054;0.118448307450912;  0
> >

[SQL] Help with a select statement design

[JORGE MALDONADO]

I have a record with the following fields:

id1, id2, id3, id4, price1, price2, price3, price4

I would like to write a SELECT statement in order to get 4 records:

id, price (record that comes from id1 and price 1)
id, price (record that comes from id2 and price 2)
id, price (record that comes from id3 and price 3)
id, price (record that comes from id4 and price 4)

I will very much appreciate any suggestion.

Respectfully,
Jorge Maldonado

Re: [SQL] Help with a select statement design

[Andreas Kretschmer]

JORGE MALDONADO  hat am 24. Dezember 2012 um 17:30
geschrieben:
> I have a record with the following fields:
>
> id1, id2, id3, id4, price1, price2, price3, price4
>
> I would like to write a SELECT statement in order to get 4 records:
>
> id, price (record that comes from id1 and price 1)
> id, price (record that comes from id2 and price 2)
> id, price (record that comes from id3 and price 3)
> id, price (record that comes from id4 and price 4)
>
> I will very much appreciate any suggestion.
>
> Respectfully,
> Jorge Maldonado

select id1 as id, price1 as price
union all
select id2, price2
union all
select id3, ... you got it?


Andreas


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Help with a select statement design

[Franz Timmer]

hello,


( select 'A' as x, id, price from tab where id = 'value'
union all select 'B' as x, id, ...
union all select 'C' as x, id, ...
union all select 'D' as x, id, price from tab where id = 'value' )

generate a list like
X   id  price
A   1   10
B   2   20
C   3   30
D   4   40

select
max (case when X = 'A' then id   end ) as id_a,
max (case when X = 'A' then price end ) as price_a,
max (case when X = 'B' then idend ) as id_b,
max (case when X = 'B' then price end ) as price_b,
max (case when X = 'C' then idend ) as id_c,
max (case when X = 'C' then price end ) as price_c,
max (case when X = 'D' then idend ) as id_d,
max (case when X = 'D' then price end ) as price_d
from ( table_or_select_from_above )

--- not testet



On 24.12.2012 17:30, JORGE MALDONADO wrote:
> I have a record with the following fields:
> 
> id1, id2, id3, id4, price1, price2, price3, price4
> 
> I would like to write a SELECT statement in order to get 4 records:
> 
> id, price (record that comes from id1 and price 1)
> id, price (record that comes from id2 and price 2)
> id, price (record that comes from id3 and price 3)
> id, price (record that comes from id4 and price 4)
> 
> I will very much appreciate any suggestion.
> 
> Respectfully,
> Jorge Maldonado


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Find Out a Way to Recover Data From Android Phone

[johnmethew]

Hi, I also faced the same problem few days back. You can easily recove all
your photos from Android phone very easily. After a lot of search I found a
software to  recover deleted picture from android phone
<”http://www.remosoftware.com/recover-pictures-from-android-phone>  . Needy
one can  download    from here.




--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Find-Out-a-Way-to-Recover-Data-From-Android-Phone-tp5735614p5738213.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql